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
Using Foreach with loop to calculate averageHi, I want to calculate average of a variable X for all households for each 200 categories on varia…
Dealing with missing dataHi, I use the following equation for calculating return for a portfolio of stocks. gen MOMf3_p1= ( …
Using Kappa / Weighted KappaDear all Please advise if I can use kappa with this data structure: With two raters (fc and lp) sco…
How to deal with "factor variable and time-series operators not allowed "when I run gllamm command?Hello all, How can I include dummy variables in gllamm?Or how can I change factor variales into dumm…
Combining summary statistics and correlation matrixHi everyone, I need to create a table combining summary statistics and correlation matrix as a part …
Subscribe to:
Post Comments (Atom)
0 Response to Counting observations in one column based on another column
Post a Comment