Pandas基础

1.常用方法

# -*- coding: UTF-8 -*-
import os
import pandas
print(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.py
D:\warkspace\pythonTest\com
<class 'pandas.core.frame.DataFrame'>
   a     b       c        d
0  1  d'sa    2321  32132.5
1  2  dsad  214214  32132.5
   a      b      c        d
4  3  safsd   3244  32132.5
5  5  dsagd  32432  32132.5
Index(['a', 'b', 'c', 'd'], dtype='object')
(6, 4)