Python - How to create a list from an excel column

Question

I have a list of names in one column of a csv file. I'm trying to make this into a list in python that looks like

list = ['name1', 'name2', 'name3']

and so on.

I have the following

import pandas as pd
export = pd.read_csv('Top100.csv', header=None)

but I can't figure out how to pull out the information and put it into a list format.

Greg Jennings · Accepted Answer · 2017-01-15 04:05:21Z

3

The below is applicable if your data is in a vertical column

export = pd.read_csv('Top100.csv', header=None)
export.values.T[0].tolist()

The .T in this transposes the values, as normally pandas is row oriented. Then you take the [0] index because Pandas reads excel or csv sheets in as a matrix, even if there's only a single column. Call the tolist() method on it and you're done.

answered Jan 15, 2017 at 4:05

Greg Jennings

1,65116 silver badges25 bronze badges

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

Comments

Adam Hughes · Accepted Answer · 2017-01-15 04:03:43Z

0

Read csv will return a pandas dataframe so your columns can be accessed through the dataframe. Say your file has columns "A", "B", "C"

import pandas as pd
data = pd.read_csv('Top100.csv', header=None)
print data["a"]

Or as a list

print list(data["a"])

answered Jan 15, 2017 at 4:03

Adam Hughes

16.5k14 gold badges100 silver badges140 bronze badges

Collectives™ on Stack Overflow

Python - How to create a list from an excel column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related