Word Analysis Project; Parse Book TItles List & Convert to Database Word List
Budget: $250 – $750 USD
This project is to perform statistical word analysis on a list of 10,000 book titles. The goal of the analysis is to generate a list of all unique words that are present in the titles, and to record the quantity of times each word appears in the list of book titles.
As an example, below is a single book title that will be processed:
Gas Trading Manual: A Comprehensive Guide to the Gas Markets
Step One:
The first step is to remove all punctuation marks from the titles. In the example above the colon “:” would be removed:
Gas Trading Manual A Comprehensive Guide to the Gas Markets
Step Two:
The next step is to parse the titles into individual words. The above title can be parsed into the following list of words:
Gas
Trading
Manual
A
Comprehensive
Guide
to
the
Gas
Markets
Step Three:
The next step is to convert the list of words into a list of unique words along with the quantity of times each word appears in the list:
Unique Word Quantity
Gas 2
Trading 1
Manual 1
A 1
Comprehensive 1
Guide 1
To 1
The 1
Markets 1
Step Four:
The last step will be to sort the list of words descending by the Quantity field and deliver the results in an Excel file.
A larger example and an Excel file containing the full list of 10,000 book titles is included in the attached project folder.
And here's the AI-generated project description.:
I have a list of book titles in a spreadsheet that I need parsed and converted into a database word list.
Key Requirements:
- Parse a provided spreadsheet of book titles
- Store words with their frequency counts in a database
Ideal Skills:
- Proficiency in database management systems (MySQL, PostgreSQL, SQLite)
- Experience with data parsing and word frequency analysis
- Ability to deliver work in an Excel file
The final deliverable should be an Excel file that contains each word from the book titles along with their frequency counts.
As an example, below is a single book title that will be processed:
Gas Trading Manual: A Comprehensive Guide to the Gas Markets
Step One:
The first step is to remove all punctuation marks from the titles. In the example above the colon “:” would be removed:
Gas Trading Manual A Comprehensive Guide to the Gas Markets
Step Two:
The next step is to parse the titles into individual words. The above title can be parsed into the following list of words:
Gas
Trading
Manual
A
Comprehensive
Guide
to
the
Gas
Markets
Step Three:
The next step is to convert the list of words into a list of unique words along with the quantity of times each word appears in the list:
Unique Word Quantity
Gas 2
Trading 1
Manual 1
A 1
Comprehensive 1
Guide 1
To 1
The 1
Markets 1
Step Four:
The last step will be to sort the list of words descending by the Quantity field and deliver the results in an Excel file.
A larger example and an Excel file containing the full list of 10,000 book titles is included in the attached project folder.
And here's the AI-generated project description.:
I have a list of book titles in a spreadsheet that I need parsed and converted into a database word list.
Key Requirements:
- Parse a provided spreadsheet of book titles
- Store words with their frequency counts in a database
Ideal Skills:
- Proficiency in database management systems (MySQL, PostgreSQL, SQLite)
- Experience with data parsing and word frequency analysis
- Ability to deliver work in an Excel file
The final deliverable should be an Excel file that contains each word from the book titles along with their frequency counts.