1.数据库连接
import pandas as pd
import pymysql
db = pymysql.connect(host='127.0.0.1', port=3306, user='root', passwd='1234', db='ncslab', charset='utf8')
sql = 'select id from test_rigs'
df1 = pd.read_sql(sql,db)
a = df1.head(2)
print(a)
df1[['列名1','列名2']][(df1['列名1']==458) & (df1['列名2']>3)]
df1[['列名1','列名2']][df1['列名1'].between(10,30,inclusive=True)
df1[['列名1','列名2']][df1['列名1'].isin(['数据1','数据2'])
df1[['列名1','列名2']][df1['列名1'].str.contains('字符串1')
df1['列名1'] = df1['列名2']*df1['列名3']
df1['列名4'] ='现金支付'
[坐标轴解释](https://www.cnblogs.com/rrttp/p/8028421.html)
df1.drop('列名1',axis = 1)
df1.drop('列名1',axis = 1,inplace = True)
df1.drop(['列名1','列名2'],axis = 1,inplace = True)
df1.columns
df1.insert(第几列,'列名',数据)
df1.drop(label=[3,4], axis = 0,inplace = True)
df1.loc[order['列名']==458, '列名'] = 45800
df1.rename(columns = ['列名1':'改变列名'],inplace = True)
df1.rename(index = ['行名':'改变行名'],inplace = True)
df1.describe()
x = '9'
y = '风扇2'
cur = db.cursor()
sql =u"INSERT INTO test(mingzi,tezheng) VALUES('%s','%s')"%(x,y)
cur.execute(sql)
db.commit()
cur.close()
db.close()
2.条件查询与增删改查