利用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