import numpy as np
import pandas as pd
from pandas import Series, DataFrame
from numpy import nan as NA
import matplotlib. pyplot as plt
plt. rcParams[ 'font.sans-serif' ] = [ 'Microsoft YaHei' ]
读取csv
pd. read_csv( 'data/ex1.csv' )
a b c d message
0 1 2 3 4 hello
1 5 6 7 8 world
2 9 10 11 12 foo
pd. read_table( 'data/ex1.csv' , sep= ',' )
a b c d message
0 1 2 3 4 hello
1 5 6 7 8 world
2 9 10 11 12 foo
df2= pd. read_csv( 'data/ex2.csv' , header= None )
df2
0 1 2 3 4
0 1 2 3 4 hello
1 5 6 7 8 world
2 9 10 11 12 foo
df3= pd. read_csv( 'data/ex2.csv' , names= [ 'aa' , 'bb' , 'cc' , 'dd' , 'message' , 'nn' ] )
df3
aa bb cc dd message nn
0 1 2 3 4 hello NaN
1 5 6 7 8 world NaN
2 9 10 11 12 foo NaN
df4= pd. read_csv( 'data/ex2.csv' ,
names= [ 'aa' , 'bb' , 'cc' , 'dd' , 'message' ] ,
index_col= 'message'
)
df4
aa bb cc dd
message
hello 1 2 3 4
world 5 6 7 8
foo 9 10 11 12
df5= pd. read_csv( 'data/csv_mindex.csv' ,
index_col= [ 'key1'