将表读入 DataFrame
包含页眉,页脚,行名称和索引列的表文件:
file:table.txt
This is a header that discusses the table file
to show space in a generic table file
index name occupation
1 Alice Salesman
2 Bob Engineer
3 Charlie Janitor
This is a footer because your boss does not understand data files
码:
import pandas as pd
# index_col=0 tells pandas that column 0 is the index and not data
pd.read_table('table.txt', delim_whitespace=True, skiprows=3, skipfooter=2, index_col=0)
输出:
name occupation
index
1 Alice Salesman
2 Bob Engineer
3 Charlie Janitor
没有行名或索引的表文件:
file:table.txt
Alice Salesman
Bob Engineer
Charlie Janitor
码:
import pandas as pd
pd.read_table('table.txt', delim_whitespace=True, names=['name','occupation'])
输出:
name occupation
0 Alice Salesman
1 Bob Engineer
2 Charlie Janitor