擅长:python、mysql、java
<pre><code>newfile = open("test.csv", "w")
for row in readerObj:
newrow = []
for item in row:
if " TB" in item:
item = item.replace(" TB", "")
item = re.sub('[^0-9]', '', item)
item = float(item) * 1024
item = round(item, 2)
elif " MB" in item:
item = item.replace(" MB", "")
item = re.sub('[^0-9]', '', item)
item = float(item) / 1000
item = round(item, 2)
elif " GB" in item:
item = item.replace(" GB", "")
item = re.sub('[^0-9]', '', item)
item = float(item)
item = round(item, 2)
newrow.append(str(item))
newfile.write(','.join(newrow) + '\n')
newfile.close()
fileToClean.close()
</code></pre>