CSV格式清洗与转换

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