pandas.read_csv
pandas 0.23.4
pandas.read_csv(filepath_or_buffer,encoding=None, usecols=None, header=’infer’, names=None)
filepath_or_buffer:CSVファイルのパス
encoding:エンコードの指定
usecols:取得するカラム(列)の指定
header: ヘッダーの行を指定
names: カラム名を指定
test.csv
col1,col2,col3,col4
00,01,02,03
10,11,12,13
20,21,22,23
30,31,32,33
example1
import pandas as pd
df = pd.read_csv("test.csv")
print(df)
# col1 col2 col3 col4
#0 0 1 2 3
#1 10 11 12 13
#2 20 21 22 23
#3 30 31 32 33
example2
import pandas as pd
df = pd.read_csv("test.csv", encoding="utf-8")
print(df)
# col1 col2 col3 col4
#0 0 1 2 3
#1 10 11 12 13
#2 20 21 22 23
#3 30 31 32 33
example3
import pandas as pd
df = pd.read_csv("test.csv", usecols=[0, 1])
print(df)
# col1 col2
#0 0 1
#1 10 11
#2 20 21
#3 30 31
test.csv
00,01,02,03
col1,col2,col3,col4
10,11,12,13
20,21,22,23
30,31,32,33
example4
import pandas as pd
df = pd.read_csv("test.csv", header=1)
print(df)
# col1 col2 col3 col4
#0 10 11 12 13
#1 20 21 22 23
#2 30 31 32 33
test.csv
col1,col2,col3,col4
00,01,02,03
10,11,12,13
20,21,22,23
30,31,32,33
example5
import pandas as pd
names = ['apple', 'orange', 'lemon', 'banana']
df = pd.read_csv("test.csv", header=0, names=names)
print(df)
# apple orange lemon banana
#0 0 1 2 3
#1 10 11 12 13
#2 20 21 22 23
#3 30 31 32 33
最近のコメント