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!

Taidot: tietojenkäsittely, Excel, Python

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Chicago, United States

Projektin tunnus: #4288276

Myönnetty käyttäjälle:


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 1 päivässä
(9 Arvostelua)

47 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 7 päivässä
(22 arvostelua)

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 Lisää

$40 USD 0 päivässä
(39 arvostelua)

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

$50 USD 1 päivässä
(59 arvostelua)

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 1 päivässä
(34 arvostelua)

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

$50 USD 1 päivässä
(33 arvostelua)

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

$100 USD 3 päivässä
(13 arvostelua)

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

$150 USD 2 päivässä
(13 arvostelua)

quick pro help. milestone required.

$100 USD 2 päivässä
(9 arvostelua)

Hi, I can help you.

$200 USD 5 päivässä
(12 arvostelua)

Hello, please check pm

$150 USD 1 päivässä
(10 arvostelua)

we are excel vba expert can solve it through vba.

$90 USD 2 päivässä
(13 arvostelua)

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

$80 USD 4 päivässä
(6 arvostelua)

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 1 päivässä
(1 arvostelu)

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

$80 USD 0 päivässä
(8 arvostelua)

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 0 päivässä
(1 arvostelu)

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

$50 USD 1 päivässä
(4 arvostelua)

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

$70 USD 2 päivässä
(6 arvostelua)

Please check PM.

$70 USD 7 päivässä
(2 arvostelua)

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 1 päivässä
(3 arvostelua)

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 1 päivässä
(7 arvostelua)