Reading specific column from a csv file in python

Question

I am writing some python code to practice for an exam in January. I need to read the second column into my code and print it out. If possible i also need to add data to specific columns.

The code i have tried is:

def view_this_weeks_sales(): #name of function

with open('employees-names1.csv ') as data: #name of csv file
    reader = csv.reader(data)
    first_column  = next(zip(*reader))
    print first_column

My file is below, it has four columns. Thanks in advance :)

Name of employee,Number of cars sold last week, Number of cars sold this week,Number of cars sold total (all on one line)

1,7,7,14

2,7,8,15

3,9,2,11

4,8,6,14

5,2,9,11

6,4,15,19

Total, ,47,84

You say you're writing python code to practice, yet I see no code in your question. You shouldn't ask stackoverflow to solve your homework for you. Please provide the code you've written so far. — Fred
– Fred, Commented Dec 20, 2018 at 18:10

marc_s · Accepted Answer · 2019-01-01 09:48:54Z

1

One way of doing this would be

import csv
#replace the name with your actual csv file name
file_name = "data.csv" 
f = open(file_name)
csv_file = csv.reader(f)
second_column = [] #empty list to store second column values
for line in csv_file:
    second_column.append(line[1])
    print(line[1]) #index 1 for second column

Second_column variable will hold the necessary values. Hope this helps.

edited Jan 1, 2019 at 9:48

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Dec 20, 2018 at 18:23

mohammed thaha jk

1561 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Reading specific column from a csv file in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related