ermutuxia 赞了您的文章 《python报错：keyerror：2》

2020-09-23 08:11

ermutuxia 回复您的文章《python按照日期升序或者降序排序》

2020-09-22 18:25

ermutuxia 回复您的文章《python按照日期升序或者降序排序》

import pandas as pd
data=pd.read_excel("D:\\360安全浏览器下载\\1600757400_452096.xlsx")
result1=pd.DataFrame()
for i in range(1,12,2):
    coli=data.iloc[:,[0,i,i+1]]
    coli.columns=["序号","日期","数值"]
    result1=pd.concat([result1,coli],axis=0)
    
result1.sort_values(by=["序号","日期"],inplace=True)

2020-09-22 18:23

ermutuxia 回复您的文章《python按照日期升序或者降序排序》

import pandas as pd

data=pd.read_excel("D:\\360安全浏览器下载\\1600757400_452096.xlsx")

result1=pd.DataFrame()

for i in range(1,12,2):

coli=data.iloc[:,[0,i,i+1]]

coli.columns=["序号","日期","数值"]

result1=pd.concat([result1,coli],axis=0)

result1.sort_values(by=["序号","日期"])

2020-09-22 18:22