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.
0 Response to Counting observations in one column based on another column
Post a Comment