In Progress

Script to analyze a CSV file

I am looking to hire an experienced programmer (with a preference for Python) for a very urgent project.

Here are the details: I have a CSV file that contains tweets published by people who ran for office during the 2012 U.S. congressional election. Each row is a unique tweet, and these are my column headers:

Candidate Name | Tweet Date | Tweet Text | Mentions? | Replies?

The "Mentions?" and "Replies?" columns either have a "1" or a "0". "1" essentially represents a "yes", and "0" represents a "no."

Note that I have all of the tweets published by each candidate, so the same Candidate Name appears in multiple rows. There are roughly 700 unique candidate names, so the total row count is pretty large.

I need a script that will analyze the CSV file and give me the following information FOR EACH CANDIDATE:

total # of tweets

total # of mentions

total # of replies

The total # of tweets is essentially just the total number of rows that contain that specific candidate name. Ideally, the output will be in its own CSV file. So, the column headers would be something like this:

Candidate Name | Total # of Tweets | Total # of Mentions | Total # of Replies

I need this completed ASAP. Please message me if you need further clarification.

To clarify:

"Mentions?" is basically whether the tweet mentions another user.
"Replies?" is whether the tweet is a reply to another user.

So I need to calculate how many tweets each user published in total, and of those, how many mentioned another user, and how many were a reply to someone else's tweet.

Sorry for the confusion!

Skills: Data Processing, Excel, Python

See more: csv python, analyze row row csv python, analyze csv file, python analyze large file, analyze file python, to hire a programmer, python programmer for project hire, python programmer for hire, need python programmer for project, need python programmer, looking to hire programmer, looking for python programmer, looking for a python programmer, i need a python programmer, i need a programmer in python, hire python programmer, hire a python programmer, hire a programmer python, urgent script analyze csv file, python programmer hire, i need to hire a c programmer, election, csv file, analyze, project need python script

About the Employer:
( 1 review ) Chicago, United States

Project ID: #4288276

Awarded to:

himakumari

Hi, I am experienced in python programming and I have done this kind of text processing for my MSc project. I can do this task for you and deliver the results within 24 Hrs. Thank you !

$30 USD in 1 day
(9 Reviews)
3.2

47 freelancers are bidding on average $73 for this job

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$240 USD in 7 days
(22 Reviews)
5.6
nagybatonyi

This job can be completed in an hour with native Excel functions for $40 if total number of tweets is less than 1,048,575 and you accept the result in a separate XLSX or CSV file. It take two or three hours if you want More

$40 USD in 0 days
(39 Reviews)
5.4
mrbrave

Lets start now and get it done in 3 hours maximum...GUARANTEED..I am Office expert and will do it through Access.

$50 USD in 1 day
(59 Reviews)
5.2
ineedWorkJob

Greetings sir, i am an expert freelancer. for this job and your 100% satisfaction is assured if you allow me to serve, for more info please cheek your message box for this project(Private)

$50 USD in 1 day
(34 Reviews)
5.1
slavisatosic

Hi Lucas, I am offering you to make this script in Excel VBA. Please see private message for details.

$50 USD in 1 day
(33 Reviews)
4.7
djain01

Hi, Please check the private message to know about my robust solution. Thanks djain01

$100 USD in 3 days
(13 Reviews)
4.4
RotorProgrammer

Hi. I can write analysis script for your data in Python. Please send me your CSV.

$150 USD in 2 days
(13 Reviews)
4.4
toinnisfree

quick pro help. milestone required.

$100 USD in 2 days
(9 Reviews)
4.2
dobreiiita

Hi, I can help you.

$200 USD in 5 days
(12 Reviews)
3.8
dreamci

Hello, please check pm

$150 USD in 1 day
(10 Reviews)
3.6
vikashgadia

we are excel vba expert can solve it through vba.

$90 USD in 2 days
(13 Reviews)
3.5
cobycecil

Hi, got a lot of experience with Python, and your project seems like a simple task. Ready to start right away. Thanks!

$80 USD in 4 days
(6 Reviews)
3.4
Aldarund

Hi. I can do this asap with a python script and provide you a result csv with a python script so you can run it yourself if you want or you have another data.

$50 USD in 1 day
(1 Review)
3.3
amelnyk

I can complete that Job in Python 3.x in a 4 hours. Ready to start right away. More in PM

$80 USD in 0 days
(8 Reviews)
3.2
fejs

Hi Sir. I'm expert in Python programming. I've finished program for You, just need to see .csv file to see what delimiter is used. Can You send me .csv file to send You a sample results? Best regards, Fejs.

$30 USD in 0 days
(1 Review)
2.8
TopSEOExpertscom

Hi, Here's my bid to get it done for you using PHP.

$50 USD in 1 day
(4 Reviews)
2.7
sujonmax

Hello sir,Ready to start Check me....

$70 USD in 2 days
(6 Reviews)
2.7
garygoog

Please check PM.

$70 USD in 7 days
(2 Reviews)
2.6
benefitworks

Hi Sir, This is very trivial. I only bid if I am 100% confident that I can complete the job. I will do it in excel vba macro. Thanks Karim

$35 USD in 1 day
(3 Reviews)
2.5
FLinCanada

Yes I can do this for you quickly, but I would do it in Excel. [The output would still be CSV, and you are welcome to reusable code.] Is that OK?

$35 USD in 1 day
(7 Reviews)
2.5