Word Analysis Project; Parse Book TItles List & Convert to Database Word List
$250-750 USD
Betales ved levering
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.
Prosjekt-ID: #38416979
Om prosjektet
Tildelt til:
Hi, I've done similar tasks many times and could help with creation of unique words list with frequencies. I could use R for main analysis and export results in excel file as you requested. I work in data analysis 10+y Mer
17 frilansere byr i gjennomsnitt $381 for denne jobben
As a data analytics expert, I have extensive experience in transforming raw data into insightful and meaningful information. My thorough understanding of statistical methods has enabled me to solve complex problems acr Mer
Hello Sir, I see you are looking to perform statistical word analysis on a list of 10,000 book titles to generate a list of all unique words present and record the frequency of each word. I can efficiently handle this Mer
Hello! I can help to complete your "Word Analysis Project; Parse Book TItles List & Convert to Database Word List" project as per your requirements. I am an MBA writer with 5 years of experience. I have all the skills Mer
Hello Stelly Z. After reading the description, I wish to confirm that I can efficiently handle your project. I have impressive skills in Data Analytics and Database Design. Having done similar tasks before, this wi Mer
Hi there, I checked your requirements and guarantee you that i have relevant experience in Python and excel it's gonna be done within the highest quality and quickly . Let's contact via chat so that I can start work im Mer
InstantQuality─── ⋆⋅☆⋅⋆ ── I am a specialized Master's degree holder equipped to tackle writing across various subjects. My commitment to work is unwavering, ensuring TOP RATED EXPERT delivers consistent and high-qua Mer
I read your proposal and am confident in my ability to complete the assignment. I can skillfully handle the Word Analysis Project; Parse Book TItles List & Convert to Database Word List because i am an Master's degree Mer
I'm an AI Engineer with over an year of experience and worked on building AI components for a level 4 Microsoft startup. The task in hand is relatively very simple and can be done with less than 50 lines of code, so I' Mer
Hey, i can do it with full constration, please try me once, If you find single mistake in your project you can deny for payment, hopefully understand
Hi I m shali Aziz, here I see a freelancer job in my field, I would like to be join on this as soon as possible, in this opportunity and experience I can see the work phase is more important on this I will be giving to Mer
As a seasoned expert in database management and an avid enthusiast of data parsing and analysis, I believe I'm the perfect fit for this prestigious project. My team at CnELIndia boasts decades of combined experience ha Mer
