python对数据进行统计-利用python 读取excel文件并对数据进行描述统计分析

from pandas.core.frame import DataFrame

import os

import math

os.chdir(" C:\A")

from openpyxl import load_workbook

airport_df = load_workbook("all_activity.xlsx")

sheets = airport_df.sheetnames

sheet_first = sheets[0]

ws2 = airport_df["Sheet2"]#读取excel中第二张表

movement=[]

name_mov=[]

for i in range(1,ws2.max_column+1):

for j in range(2,ws2.max_row+1):

cellr=ws2.cell(j,i)

movement.append(cellr.value)

ln_movement=[]

for j in range(len(movement)):

ln_movement.append(math.log(movement[j]))###计算对数值

mt=DataFrame(ln_movement,index=range(1,631),columns=["movement"]) 建立

mt.describe()###描述统计

运行结果如下：

movement

count  630.000000

mean    11.261194

std      1.233674

min      4.346268

25%     10.644837

50%     11.202507

75%     11.893310

max     17.191881