这个结果生成的表还是按照列排序的，我想按照行排序，比如第一行客户后面每行日期按照行升序或者降序排序，不要变成列

df = pd.read_excel(r"C:\Users\12234\Desktop\bin\1600757400_452096.xlsx")

df

kk = pd.DataFrame()

qq = range(1,12,2)

for i in qq:

cut1 = df.iloc[:,[i,i+1]]

ss1 = cut1.sort_values(by=["日期{num}".format(num=qq.index(i)+1)],ignore_index=True)

kk = pd.concat([kk,ss1],axis=1)

# kk.reset_index(drop = True,inplace = True)

kk

测试评论的评论1

测试

不错

排序后可以还是横着展现吗？日期和日期后面的数字还是都在一行，但是在每行里面都按照日期升序或者降序排列

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)

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=["序号","日期"])

很好

类似我发的图片 ， 用execute（）方法操作即可

# -*- coding: utf-8 -*-
"""
Created on Tue Sep 22 11:12:16 2020
@author: Administrator
"""
#导入库
import pandas as pd
import numpy as np
#准备两个数据框data1,data2
data1=pd.DataFrame(np.array(range(15)).reshape(3,5))
data2=data1.copy()
#将两个数据框导入到一个excel文件的两个不同sheet里面
with pd.ExcelWriter("D://FFF.xlsx") as writer:  # doctest: +SKIP
    data1.to_excel(writer, sheet_name='Sheet_name_1')
    data2.to_excel(writer, sheet_name='Sheet_name_2')

如果我本地上传了一个文件到python,读取文件后怎么在python 里面用sql代码处理这个文件呢

import pandas as pd

import numpy as np

import ast

df = pd.read_excel(r"D:\data\1600409334_419096.xlsx")

ss = df.respdata.values[0]

d = ast.literal_eval(ss)

df0 = pd.DataFrame(d)

df0.data.loc["result"]['detail']

pd.DataFrame(df0.data.loc["result"]['detail'],index = [0,1])

对，这样可以，代码可以看下吗，谢谢

这样？