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
所有选项都可以在此处的熊猫文档中找到
热门推荐
3 祝福语简短的微信
10 幼儿祝福语大全简短贺卡
11 感谢教官文案祝福语简短
12 鼠年同事祝福语简短创意
13 元旦祝福语 简短独特群发
14 妈咪跟我生日祝福语简短
15 给儿子新婚祝福语简短
16 伴娘祝福语长文案简短
17 恭喜高考完祝福语简短
18 生日祝福语送老公简短