import pandas as pd import numpy as np

data = {'订单号':['D001','D002','D003','D004'], '设备 ID':['E1','E2','E3','E4'], '购买数量':[1,3,7,9], '应付金额':[3.5,4.5,5, np.nan], '商品名称':['可乐','营养快线','八宝粥','酸奶'], '支付时间':['2020-1-2','2020-2-3','2020-3-4','2020-4-5'], '地点':['A','B','C','D']}

df = pd.DataFrame(data) df

df.shape

输出： (4, 7)

df.info()

输出： <class 'pandas.core.frame.DataFrame'> RangeIndex: 4 entries, 0 to 3 Data columns (total 7 columns):

Column Non-Null Count Dtype

0 订单号 4 non-null object 1 设备 ID 4 non-null object 2 购买数量 4 non-null int64
3 应付金额 3 non-null float64 4 商品名称 4 non-null object 5 支付时间 4 non-null object 6 地点 4 non-null object dtypes: float64(1), int64(1), object(5) memory usage: 352.0+ bytes

df.describe()

输出： 购买数量 应付金额 count 4.000000 3.000000 mean 5.000000 4.333333 std 3.605551 0.577350 min 1.000000 3.500000 25% 2.500000 4.000000 50% 5.000000 4.500000 75% 7.500000 4.750000 max 9.000000 5.000000

df['支付方式'] = ['微信','现金','支付宝','微信'] d