Script to analyze a CSV file

This project was successfully completed by himakumari for $30 USD in a day.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
Project Description

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.

Completed by:
Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online