Python – pandas csv

pandas csv

pandas has read_csv

Sample

No header, No header define

Data(data.csv)

1,2,3
4,5,6
7,8,9

Sample

p = pd.read_csv("data.csv", header=None)
print(p)
print(type(p))   # <class 'pandas.core.frame.DataFrame'>

'''

   0  1  2
0  1  2  3
1  4  5  6
2  7  8  9

'''

No header, header define

import pandas as pd

# Change header name
p = pd.read_csv("data.csv", names=('1', '2', '3'))
print(p)

'''

   1  2  3
0  1  2  3
1  4  5  6
2  7  8  9

'''

Header

Data(datawithheader.csv)

col1,col2,col3
1,2,3
4,5,6
7,8,9

import pandas as pd

p = pd.read_csv("datawithheader.csv")
print(p)

'''

   col1  col2  col3
0     1     2     3
1     4     5     6
2     7     8     9


'''
print(p['col1'])

'''

0    1
1    4
2    7

'''