Find Jobs
Hire Freelancers

Combine similar entries in 14,000 row spreadsheet of song + artist titles, and average scores for duplicate entries.

$30-250 USD

Completed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I have an aggregate spreadsheet containing 14,000 songs each with the artist, year, title and score. Many rows are duplicates, but the spelling of each is slightly different. An example would be "'Bob Dylan' vs 'Dylan, Bob'" for an Artist and "' Sittin' vs. 'Sitting' " as a song title. The same song might also appear twice with different years. Those should count as separate. Each song has a score, and an aggregate score needs to be created for the multiple occurrences of each song per year. I've started an R Script for this purpose which uses several libraries that use levenshtein and n-gram methods for text analysis and string distance techniques. I'd like a script I can reuse for this purpose with other similar tables.
Project ID: 14614077

About the project

16 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
It's just some basic data manipulation. I think there so many ways to do it. The challenge would be coming up with an R script with the least number of steps.
$35 USD in 3 days
5.0 (2 reviews)
2.4
2.4
16 freelancers are bidding on average $94 USD for this job
User Avatar
Hello Sir Im excel VBA macro and formula Expert. i can make script for remove your duplicate songs :) Relevant Skills and Experience my main skill in VBA Excel macro script :) so please chat me for more detail about your project SIr :) Proposed Milestones $30 USD - intial milestone
$30 USD in 1 day
4.9 (205 reviews)
6.8
6.8
User Avatar
Hello TheQuiet , I have read your project description and understood your requirement. I can use excel formulas to simplify this work. I have 5 years experience in Excel advanced concepts. Relevant Skills and Experience Skills : Excel, Macros,VB.net, Web scraping, Data entry, Copy typing, Transcription works Proposed Milestones $30 USD - A
$30 USD in 1 day
4.9 (238 reviews)
6.9
6.9
User Avatar
Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satisfaction. I have also good experience for Website designing, product listing for various forum, magenta, word press, PDF branding (like designing, Branding, editable PDF & conversion etc), web research and searching, Adobe Photoshop/ Corel graphic designing. I have ALISON certified for MS Excel, Excel & Formula, Powerpoint, Word & office 2010. 10 year computer operator and Administrator in an organization. My Freelancer profile and portfolio also show my experience. I am really interested in this project so please give me chance, I hope it will be nice experience for both of us. I will provide you best service in lowest budget with complete accuracy. ready to start now. I have very cooperative nature person and I always give preference to clients satisfaction Regards
$30 USD in 1 day
4.9 (95 reviews)
6.0
6.0
User Avatar
Dear Employer, I did similar works, and I could handle your project well in appropriate time. Relevant Skills and Experience To do this job I'll try to build a combined index for each row of your table of the base of purified words from Author and Title columns. I can manage this work in 2 or 3 days. Proposed Milestones $100 USD - We'll state my bid price together, I hope. If you even will not choose me for that project, I’d like to be useful for you in future projects.
$100 USD in 3 days
5.0 (63 reviews)
6.0
6.0
User Avatar
I've 5 years of experience of MS Excel and data entry, I can do this work, do let me know of further details. Relevant Skills and Experience MS Exccel, Data entry Proposed Milestones $100 USD - Upon Completion
$100 USD in 1 day
4.4 (18 reviews)
4.7
4.7
User Avatar
I can develop this similar program on Excel Macros.. I have 7 years of experience with 100% client satisfaction history. See my profile for client reviews. Relevant Skills and Experience Excel, VBA Proposed Milestones $250 USD - Final Looking for your response.
$250 USD in 1 day
4.8 (10 reviews)
3.9
3.9
User Avatar
Let's start Expert VA here,I have Understand Sir, I will do it Asap, Already Done Many Similar Project's, I will assure you that i will provide 100% Satisfaction Guarantee. Relevant Skills and Experience PHP, HTML, CSS, JAVASCRIPT, JQUERY, NODE.JS, AJAX, GRAPHICS DESIGN, WORDPRESS, OSCOMMERCE, PSD TO HTML, PSD TO WORDPRESS, WEBSITE SPEED OPTIMAZATION Data Entery, Data Processing & Excel Proposed Milestones $99 USD - MILESTONE
$99 USD in 3 days
4.9 (2 reviews)
1.9
1.9
User Avatar
Hi I think I can create php script (it is simplier for me) wich will analyze all these Give this spreadsheet please Thanks Relevant Skills and Experience Analuzing Developing Algorythms Proposed Milestones $120 USD - all
$120 USD in 4 days
5.0 (1 review)
1.8
1.8
User Avatar
I have read the "Combine similar entries in 14,000 row spreadsheet of song + artist titles, and average scores for duplicate entries." project description in details and have decided to offer my services to work on your Data entry project. I have 3+ years of experience in Data entry project. And I am interest in the lowest rates. Reporting:I will send you a custom status report of work every-day/weekly/monthly regarding your demand. Reporting will include all necessary data. Advance Thanks Sumon Das
$88 USD in 3 days
4.8 (1 review)
0.1
0.1
User Avatar
I can Start working Immediately. Hope you are in good health, I am 3 years experienced Data Entry & Research professional and I am an expert in my field. Relevant Skills and Experience Quality is just a click away from you so click on the hire button on my profile and get the best quality today. Quality you deserve Quality I serve Proposed Milestones $155 USD - milestone
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very much interested on this job. Relevant Skills and Experience I have more than 10 years experience of data processing. Proposed Milestones $100 USD - 90% of the job done $11 USD - 10% of the job done Additional Services Offered $1 USD - if you need correction of the job.
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$50 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
ok Relevant Skills and Experience ok Proposed Milestones $50 USD - first instalment $50 USD - on final delivery
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Austin, United States
5.0
38
Payment method verified
Member since Apr 4, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.