Python数据分析学习笔记-pandas库学习4

行列转置

原表：

.T方法不会直接改变原表

lis6=lis5.T
print(lis6)

pandas数据的导入

导入txt： read_table

尽量使用相对路径

table1=pd.read_table('./testfile.txt',)
print(table1)

单列表格结果：

多列表格结果：
txt文件中每列用tab隔开，pandas自动分列

非tab分割处理

原数据：

01:Brett:14:155:viloin
02:Eddy:13:156:piano
03:Jordon:13:165:compose

用:分列，并增加列名：

table1=pd.read_table('./testfile.txt',sep=':',header=None,names=['id','name','age','height','habit'])
print(table1)

导入csv： read_csv

table2=pd.read_csv('./csvtest.csv')
print(table2)

导入excel:read_excel

需要先安装xlrd

table3=pd.read_excel('./xltest.xls')

导入html:read_html

需要先安装lxml
取回的是列表

table4=pd.read_html('./htmltest.html',header=0)  #header放在第0行
print(table4)

[ Name Color Description
0 Apple Red These are red.
1 Pear Green These are green.
2 Grape Purple / Green These are purple and green.
3 Orange Orange These are orange.
4 Banana Yellow These are yellow.
5 Kiwi Green These are green.
6 Plum Purple These are Purple
7 Watermelon Red These are red.
8 Tomato Red These are red.
9 Cherry Red These are red.
10 Cantelope Orange These are orange inside.
11 Honeydew Green These are green inside.
12 Papaya Green These are green.
13 Raspberry Red These are red.
14 Blueberry Blue These are blue.
15 Mango Orange These are orange.
16 Passion Fruit Green These are green., 01 02 03
0 Apple Red These are red.
1 Pear Green These are green.]

文件中有两个table，读取列表：

print(table4[0],'\n',table4[1])

使用class标签进行表筛选
取回指定class下的列表

table4=pd.read_html('./htmltest.html',header=0,attrs={'class':'fixed_headers'})
print(table4)

[ Name Color Description
0 Apple Red These are red.
1 Pear Green These are green.
2 Grape Purple / Green These are purple and green.
3 Orange Orange These are orange.
4 Banana Yellow These are yellow.
5 Kiwi Green These are green.
6 Plum Purple These are Purple
7 Watermelon Red These are red.
8 Tomato Red These are red.
9 Cherry Red These are red.
10 Cantelope Orange These are orange inside.
11 Honeydew Green These are green inside.
12 Papaya Green These are green.
13 Raspberry Red These are red.
14 Blueberry Blue These are blue.
15 Mango Orange These are orange.
16 Passion Fruit Green These are green.]

读取MySQL：read_sql

import pymysql
con = pymysql.connect(host='localhost',user='root',password='Peach0128sql',database='listboard',charset='utf8',use_unicode=True)
sqlcmd='select 型号,WiFi频段 from gw1115'
df=pd.read_sql(sqlcmd,con)
print(df.head(5)) #打印5行