I have a dataset concerning music that has one column which contains the number of plays the song has gotten, a column with the year, a column with the song name, and a column that records a "1" if the song contains the word "today", "0" otherwise. If I wanted to count how many plays songs with the word "today" has gotten, how would I go about that? I have tried
count plays if title_today>0
but this does not work.
Related Posts with Counting observations in one column based on another column
Cumulative Totals in Unbalanced Time Series DataI have not been able to figure out how to leverage time-series data (tsset) and its efficiencies to …
How can I change the scale of the y-axis in a Barchart Hello, I would be very grateful if someone could help me with the scale of the y-axis of my barcha…
Generate and replace multiple variables based on original variables.Hello Statalist, Hope everyone is doing fine in the middle of this pandemic. I'm working with a da…
Difference in SE and CI using svyset v. pweight - reason for difference?I am working on analyzing survey data which was collected using a stratified random sample, with dis…
Can't find PIPI'm running Spyder Python 3.3.6 from Stata/IC 16.1 for Mac (64-bit Intel): Code: . python query --…
Subscribe to:
Post Comments (Atom)
0 Response to Counting observations in one column based on another column
Post a Comment