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
Problem with instruments in the spivregressDear All, I am estimating a spatial IV model using the files that you can download from here. They …
Data transformationDear Statatist, I have try reshape and stack command but still can't solve the problem related to …
"Expanding" a count variable within a panel datasetHello. My PI has asked me to create new rows from two existing variables (see num and den below). Us…
Divide panel data into subgroupsDear Statalist, I am working on a panel dataset (xtset firm year). I want to divide the firms into…
Regression Discontinuity on Iraq Cholera DataI am currently working with a difference-in-difference model specified as follows: log(Viewsit)= B…
Subscribe to:
Post Comments (Atom)
0 Response to Counting observations in one column based on another column
Post a Comment