有一个pandas describe函数：

dataset.describe(include = "all")

字符串
在一个比describe更好的答案方面，有一个问题是将值转换（如果可能的话）为数值类型。所以我不得不进行繁琐的检查：

import pandas as pd
import numpy as np

df = pd.read_excel("Dataset.xlsx") # import data from op's file
df_new = pd.DataFrame(columns=df.columns) # generate an empty copy with headers

for col in df.columns: # go through columns
    if df[col].dtypes == "object": # check if object, if yes go in, if no assign to df_new
        values = list() # init empty list
        for val in df[col].values: # for every value in the column
            if pd.isna(val): # if it is nan, append it to values
                # print("Nan detected in "+str(val))
                values.append(np.nan) # append
            elif " " in val: # if there are spaces, this hints to the existence of number + unit
                # print("space detected in "+val)
                val_splitted = val.split(" ") # split with space
                if "," in val_splitted[0]: # if there is a comma, since the dec points are sometimes with , and sometimes with .
                    val_splitted[0] = val_splitted[0].replace(",", ".") # replace , with .
                if len(val_splitted) == 2: # if there are only two values in the splitted form
                    # print("one space detected in "+val)
                    try: # try to convert to float
                        if col == "SSD Capacity": # only here, since the unit switches between GB and TB
                            if val_splitted[1] == "GB": # 
                                values.append(float(val_splitted[0])/1000) # append divided by 1000
                            else: # else
                                values.append(float(val_splitted[0])) # assign as is
                        else: # if it is not the column SSD Capacity
                            values.append(float(val_splitted[0])) # append the val as is
                    except ValueError: # oops! value cannot be converted, then it is not numeric
                        values.append(val) # assign as is
                else:
                    #print("too many spaces inm keeping "+val+" as it is") 
                    values.append(val) # if too many spaces, such as "1920 x 1080" append as is
            else:
                # print("keeping "+val+" as it is")
                values.append(val) # if no spaces and not nan, assign as is
        df_new[col] = values # assign the values to the column in df_new
    else:
        df_new[col] = df[col] # if the value is not an object type, assign the whole column to df_new
        
print(df_new.describe(include = "all")) # print description

型
结果是这样的：
| | 屏幕尺寸|背光|最大处理器速度|RAM（系统内存）|SSD容量| SSD Capacity |
| --|--|--|--|--|--|--|
|计数| 八十八万八千|九十九万四千|九十九万四千|九十五万|九十八万七千|九十九万一千|
|mean| 三三三九八七四|15.336| 0.243|四点二九三|十七点四三一|0.638|
|std| 626.284|零点九二三|0.429|零点六一六|十二点二三五|零点四二三|
|min| 1066.000|一万|000|一千零五十|四千|000|
|25%| 三千二百万|一万五千六百|000|四千二百|八千|0.500|
|50%| 三千二百万|一万五千六百|000|四千四百|一万六千|零点五一二|
|75%| 三千二百万|一万五千六百|000|四千七百|一万六千|一千|
|最大| 六千四百万|一万八千四百|一千|五千六百|十二万八千|四千|