data mining 3 data import

import pandas as p
a=p.read_csv("E:/m/b.csv")
a1=a.describe()
a2=a.sort_values(by="1")#first line(head line)
print(a1,a2)

b=p.read_excel("E:/m/a.csv")

import pymysql
con=pymysql.connect(host="127.0.0.1",user="root",passwd="root",db="spider")
select1="select * from iterms"
e=p.read_sql(select1,con)

c=p.read_html("E:/m/c.html")
c1=p.read_html("http://www.dsec.gov.mo/Statistic.aspx?NodeGuid=d5a3d867-b0ee-4fd0-abcc-dca4ecd310fe")
print(c,c1)

d=p.read_table("E:/m/d.txt")
print(d)

转载于:https://www.cnblogs.com/rabbittail/p/7737933.html