Count occurrences in column | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Count occurrences in column

Hello, I’ve data with a column that has many occurrences. For example in a line you can find two words or more, there’s 21000 lines. How do I know the number times that a word appears without knowing the word? Thanks

27th Feb 2018, 12:30 AM
abdoul
abdoul - avatar
2 Answers
+ 9
Hmm... I don't know which language this is for, or if you want to total everything or prompt for a wanted word. But it might work something like this: Store 21000 lines in a file Copy file contents to string variable Make a dictionary, 2 lists (string for words, int for occurrences), or 1 list of objects (string word, int count) While not at end of file string word While current char in file isn't a space Read 1 char If char not punctuation Add to word end while If word not in array/dictionary/list Add to list If word is in list occurrences += 1 //Adds to number of occurrences for that word Advanced forward 1 char to skip space end while for each item in list/array/dictionary print word, print occurrences
27th Feb 2018, 1:08 AM
Tamra
Tamra - avatar
+ 3
Speaking the power of variables and comparison, its possible. but which language /?
27th Feb 2018, 1:06 AM
Nura Programmer
Nura Programmer - avatar