pandas 将表读入DataFrame
示例
具有页眉,页脚,行名和索引列的表文件:
文件: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
没有行名或索引的表文件:
文件: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
所有选项都可以在此处的熊猫文档中找到
热门推荐
7 天仙配简短祝福语
10 生日祝福语对妈妈简短
11 国庆中秋祝福语大全简短
12 致敬大国工匠祝福语简短
13 中秋祝福语简短带署名
14 生日祝福语已婚朋友简短
15 20春节祝福语大全简短
16 调皮祝福语老师文案简短
17 祝女儿结婚简短祝福语
18 祝福语送超市同事简短