Rank word frequent in a list

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Rank word frequent in a list

standenman
Wafer-Thin Wafer

Posts: 80

Threads: 36

Joined: Jan 2018

Reputation: 0

Nov-07-2018, 09:11 PM

I'm a non-coder type, so sorry if I don't have a clue on how to do this. I have Column in an excel spreadsheet with hospital names. I want to basically count the number of time the same word or word phrase appears in the list. So for this short lists (which it is not) of
"Dallas Medical Center"
Hospital of Dallas"
"Presbyterian Medical Hospital"

I would like a like for the code to give "Medical", "Hospital" and "Dallas" a rank of 2; "Center", and "Presbyterian" a rank of 1 Thanks so much.

Find

Messages In This Thread

Rank word frequent in a list - by standenman - Nov-07-2018, 09:11 PM

RE: Rank word frequent in a list - by Larz60+ - Nov-07-2018, 09:24 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	For Word, Count in List (Counts.Items())	new_coder_231013	6	3,005	Jul-21-2022, 02:51 PM Last Post: new_coder_231013
	find some word in text list file and a bit change to them	RolanRoll	3	1,675	Jun-27-2022, 01:36 AM Last Post: RolanRoll
	Problem: Check if a list contains a word and then continue with the next word	Mangono	2	2,665	Aug-12-2021, 04:25 PM Last Post: palladium
	Trying to get the first letter of every word in a list	DanielCook	2	2,263	Jan-05-2021, 05:06 PM Last Post: deanhystad
	Trying to find first 2 letter word in a list of words	Oldman45	7	3,977	Aug-11-2020, 08:59 AM Last Post: Oldman45
	Cant Append a word in a line to a list err "str obj has no attribute append	Sutsro	2	2,741	Apr-22-2020, 01:01 PM Last Post: deanhystad
	Python Speech recognition, word by word	AceScottie	6	16,301	Apr-12-2020, 09:50 AM Last Post: vinayakdhage
	print a word after specific word search	evilcode1	8	5,098	Oct-22-2019, 08:08 AM Last Post: newbieAuggie2019
	How do you replace a word after a match from a list of words in each line of a file?	vijju56	1	3,572	Oct-17-2019, 03:04 PM Last Post: baquerik
	returns index of list if contains a word	zarize	0	1,909	Sep-09-2019, 09:29 AM Last Post: zarize

Users browsing this thread: 1 Guest(s)

View a Printable Version

Rank word frequent in a list

User Panel Messages

Announcements