python dataframe 列宽_python的dataFrame操作方法

importpandas as pd

l1=list()#tprice代表总价

d10={"date":"2021-01-03","tprice":10000}

d11={"date":"2021-01-04","tprice":10200}

l1.append(d10)

l1.append(d11)

pd1= pd.DataFrame(l1,columns = ['date', 'tprice'])print(pd1)

l2=list()#pnumber代表商品数量

d20={"date":"2021-01-03","pnumber":500}

d21={"date":"2021-01-04","pnumber":425}

l2.append(d20)

l2.append(d21)

pd2= pd.DataFrame(l2,columns = ['date', 'pnumber'])print(pd2)#把两个dataFrame合并成一个新的dataFrame

pd_merge = pd.merge(pd1, pd2, left_on="date", right_on="date")print(pd_merge)#一个dataFrame的行数

i_rows =pd_merge.shape[0]print("pd_merge 行数:%r" %(i_rows))#一个dataFrame的列数

i_cols = pd_m