Python Realizes Mysql Data Statistics and numpy Statistical Functions

The example code for Python to implement Mysql data statistics is as follows:

import pymysql
import xlwt
excel=xlwt.Workbook(encoding='utf-8')
sheet=excel.add_sheet('Mysql Database ')
sheet.write(0,0,' Library name ')
sheet.write(0,1,' Table name ')
sheet.write(0,2,' Number of data strips ')
db=pymysql.connect('192.168.1.74','root','123456','xx1')
cursor=db.cursor()
sql="select TABLE_SCHEMA as 'database',TABLE_NAME as table_name from information_schema.TABLES where TABLE_SCHEMA in ('my1','my2','t1','xx1');"
i=0
try:
 cursor.execute(sql)
 res1=cursor.fetchall()
 for row in res1:
 database=row[0]
 table=row[1]
 c1=row[0]+'.'+row[1]
 c2='select count(*) from %s'%c1
 try:
  cursor.execute(c2)
  res2=cursor.fetchall()
  for num in res2:
  count=num[0]
  i=i+1
  sheet.write(i,0,database)
  sheet.write(i,1,table)
  sheet.write(i,2,count)
 except:
  print('Error,Please check your code')
except:
 print('Error,Please check your code')
excel.save('C:\\Users\\user\\DeskTop\\mysql.xls')
db.close()

PS: Let's look at the Python data analysis numpy statistical function

np. mean (x [, axis]):
Average of all elements, parameter number or ndarray
np. sum (x [, axis]):
The sum of all elements, the parameter is number or ndarray
np. max (x [, axis]):
Maximum value for all elements, parameter number or ndarray
np. min (x [, axis]):
Minimum value for all elements, parameter number or ndarray
np. std (x [, axis]):
Standard deviation of all elements, parameter is number or ndarray
np. var (x [, axis]):
Variance of all elements, parameter number or ndarray
np. argmax (x [, axis]):
Subscript index value of the maximum value, and the parameter is number or ndarray
np. argmin (x [, axis]):
The subscript index value of the minimum value, and the parameter is number or ndarray
np. cumsum (x [, axis]):
Returns an array with the same latitude, each element is the cumulative sum of all previous elements, and the parameter is number or ndarray
np. cumprod (x [, axis]):
Returns an array of the same latitude, each element being the cumulative product of all previous elements, with arguments number or ndarray

Summarize