Pandas基础

1.常用方法

# -*- coding: UTF-8 -*-import osimport pandasprint(os.getcwd())dt=pandas.read_excel("C:\\Users\\asus\\Desktop\\aaa.xlsx",delimiter="\t")print(type(dt))print(dt.head(2))print(dt.tail(2))print(dt.columns)print(dt.shape)

输出：

D:\python\python.exe D:/warkspace/pythonTest/com/Pandas1.pyD:\warkspace\pythonTest\com<class 'pandas.core.frame.DataFrame'>   a     b       c        d0  1  d'sa    2321  32132.51  2  dsad  214214  32132.5   a      b      c        d4  3  safsd   3244  32132.55  5  dsagd  32432  32132.5Index(['a', 'b', 'c', 'd'], dtype='object')(6, 4)