I have a text file containing tweets by users where:
470192 anneJackson Apple's new iPhone is a no go for me 470193 trex90 For something so expensive, I'll go for Android anyway 470194 anneJackson What an outrageous pricing!
where the first column denotes an ID, followed by the username and user's tweet. What i want to do now is to write a command to count the number of tweets by each unique user which gives me something like:
anneJackson 2 trex 1
I tried something like:
cut -f 2 Twitter_Data_1 | sort | uniq -c
but it doesn't feel right as I'm only using the user column not including the tweet.