擅长:python、mysql、java
<pre><code>import csv
import io
output = io.StringIO()
data = """<COLUMNS> BathsFull BathsHalf BedsTotal MatrixModifiedDT Status </COLUMNS>
<DATA> 1 1 3 2020-06-21T07:48:04.327 ACTV </DATA>
<DATA> 2 0 3 2020-06-03T09:30:38.177 ACTV </DATA>
<DATA> 1 0 2 2020-08-31T09:45:45.430 ACTV </DATA>"""
#print(data)
fieldnames = ['<COLUMNS>', 'BedsTotal', 'Status', '</COLUMNS>']
writer = csv.DictWriter(output, fieldnames=fieldnames, delimiter=' ', extrasaction='ignore')
writer.writeheader()
c = csv.DictReader(data.splitlines(), delimiter=' ')
for row in c:
#print(row['Status'])
writer.writerow(row)
print(output.getvalue())
output.close()
</code></pre>