CSV格式清洗与转换
(1)按行进行倒序排列;
(2)每行数据倒序排列;
(3)使用分号(;)代替逗号(,)分割数据,无空格;
f = open('data.csv', 'r', encoding='utf-8')
lslist = []
for line in f.readlines():
line = line.strip("\n").replace(" ","") # 去除空格
data = ";".join(line.split(",")[::-1])
lslist.insert(0,data)
for row in lslist:
print(row)
data.csv数据:
1,2,3,4,5,6,7
8, 3, 2, 7, 1, 4, 6, 5
6, 1, 3, 8, 5, 7, 4, 2
‘a’,‘b’,‘c’,‘x’,‘y’,‘z’,‘i’,‘j’,‘k’
‘k’, ‘b’, ‘j’, ‘c’, ‘i’, ‘y’, ‘z’, ‘a’, ‘x’
‘z’, ‘c’, ‘b’, ‘a’, ‘k’, ‘i’, ‘j’, ‘y’, ‘x’
‘a’, ‘y’, ‘b’, ‘x’, ‘z’, ‘c’, ‘i’, ‘j’, ‘k’
5, 2, 4, 7, 1, 6, 8, 3