求大神帮助，python中怎么实现文本1-5转为1,2,3,4,5

python处理Excel表格里面的文本数据，其中1列都是1-5，或者1-6的文本格式数据，
怎么将文本1-5转为1,2,3,4,5的格式，1-6转为1,2,3,4,5,6

参考

1. import pandas as pd
   
2. df=pd.read_excel('test.xlsx')
   
3. 
   
4. def exdata(x):
   
5.     lit=x.split('-')
   
6.     start=int(lit[0])
   
7.     end=int(lit[1])+1
   
8.     result=[i for i in range(start,end)]
   
9.     return ','.join([str(j) for j in result])
   
10. df['转为新格式数据']=df['原始数据'].apply(exdata)
    

复制代码

感谢，能够实现原定计划功能

Dim b

xxx = ThisWorkbook.Sheets("序列转换").Range("A1048576").End(xlUp).Row
For aaa = 2 To xxx

a = Left(Cells(aaa, 1), Application.WorksheetFunction.Find("-", Cells(aaa, 1)) - 1)
b = Mid(Cells(aaa, 1), Application.WorksheetFunction.Find("-", Cells(aaa, 1)) + 1, 10)
c = Int(b) - Int(a)
For i = 1 To c
    x = a + i
    Z = Z & "," & x
   
Next

ThisWorkbook.Sheets("序列转换").Cells(aaa, 2).Value = a & Z
Z = ""
Next

End Sub

wsen 发表于 2021-12-20 15:00
Dim b

xxx = ThisWorkbook.Sheets("序列转换").Range("A1048576").End(xlUp).Row

这个是使用VB写的代码

来自‘ask.csdn.net’网站用户[user-from-future]的解答

print(tuple(range(*(lambda mi, ma: (int(mi), int(ma) + 1))(*input("num range: ").split("-")))))