基于以下link:
我可以轻松格式化一台MAC电脑.但是我在try 从csv文件中执行多个操作时遇到了一个问题.当我运行文件时,它会转换它们,但脚本会将每个文件转换6次.如果我加上"return",那么它只转换前一个6次.
def readfile_csv():
with open('ap_macs.csv', 'r',encoding='utf-8-sig') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
for lines in csv_reader:
data = (lines[0])
for i in range(0,12,2):
format_mac = ':'.join(data[i:i + 2] for i in range(0, 12, 2))
print(format_mac.swapcase())
理想的情况下,我希望能用Pandas和Excel来做这件事,但是索引让我很痛苦.谢谢你的帮助.非常感谢.
ap_macs
A1B2C3D4E5F6
A1B2C3D4E5F7
A1B2C3D4E5F8
A1B2C3D4E5F9
a1b2c3d4e5f6
a1b2c3d4e5f7
a1b2c3d4e5f8
a1b2c3d4e5f9