Python處理CSV、JSON和XML數(shù)據(jù)的簡便方法

CSV數(shù)據(jù)

import?csv?

filename?=?"my_data.csv"

fields?=?[]?
rows?=?[]???
#?Reading?csv?file?
with?open(filename,?'r')?as?csvfile:?
????#?Creating?a?csv?reader?object?
????csvreader?=?csv.reader(csvfile)?

????#?Extracting?field?names?in?the?first?row?
????fields?=?csvreader.next()?

????#?Extracting?each?data?row?one?by?one?
????for?row?in?csvreader:?
????????rows.append(row)??
#?Printing?out?the?first?5?rows?
for?row?in?rows[:5]:?
????print(row)

import?csv?

#?Field?names?
fields?=?['Name',?'Goals',?'Assists',?'Shots']?

#?Rows?of?data?in?the?csv?file?
rows?=?[?['Emily',?'12',?'18',?'112'],?
?????????['Katie',?'8',?'24',?'96'],?
?????????['John',?'16',?'9',?'101'],?
?????????['Mike',?'3',?'14',?'82']]

filename?=?"soccer.csv"

#?Writing?to?csv?file?
with?open(filename,?'w+')?as?csvfile:?
????#?Creating?a?csv?writer?object?
????csvwriter?=?csv.writer(csvfile)?

????#?Writing?the?fields?
????csvwriter.writerow(fields)?

????#?Writing?the?data?rows?
????csvwriter.writerows(rows)

import?pandas?as?pd
from?dicttoxml?import?dicttoxml
import?json

#?Building?our?dataframe
data?=?{'Name':?['Emily',?'Katie',?'John',?'Mike'],
????????'Goals':?[12,?8,?16,?3],
????????'Assists':?[18,?24,?9,?14],
????????'Shots':?[112,?96,?101,?82]
????????}

df?=?pd.DataFrame(data,?columns=data.keys())

#?Converting?the?dataframe?to?a?dictionary
#?Then?save?it?to?file
data_dict?=?df.to_dict(orient="records")
with?open('output.json',?"w+")?as?f:
????json.dump(data_dict,?f,?indent=4)

#?Converting?the?dataframe?to?XML
#?Then?save?it?to?file
xml_data?=?dicttoxml(data_dict).decode()
with?open("output.xml",?"w+")?as?f:
????f.write(xml_data)

JSON數(shù)據(jù)

import?json
import?pandas?as?pd

#?Read?the?data?from?file
#?We?now?have?a?Python?dictionary
with?open('data.json')?as?f:
????data_listofdict?=?json.load(f)

#?We?can?do?the?same?thing?with?pandas
data_df?=?pd.read_json('data.json',?orient='records')

#?We?can?write?a?dictionary?to?JSON?like?so
#?Use?'indent'?and?'sort_keys'?to?make?the?JSON
#?file?look?nice
with?open('new_data.json',?'w+')?as?json_file:
????json.dump(data_listofdict,?json_file,?indent=4,?sort_keys=True)

#?And?again?the?same?thing?with?pandas
export?=?data_df.to_json('new_data.json',?orient='records')

import?json
import?pandas?as?pd
import?csv

#?Read?the?data?from?file
#?We?now?have?a?Python?dictionary
with?open('data.json')?as?f:
????data_listofdict?=?json.load(f)

#?Writing?a?list?of?dicts?to?CSV
keys?=?data_listofdict[0].keys()
with?open('saved_data.csv',?'wb')?as?output_file:
????dict_writer?=?csv.DictWriter(output_file,?keys)
????dict_writer.writeheader()
????dict_writer.writerows(data_listofdict)

XML數(shù)據(jù)

import?xml.etree.ElementTree?as?ET
import?xmltodict
import?json

tree?=?ET.parse('output.xml')
xml_data?=?tree.getroot()

xmlstr?=?ET.tostring(xml_data,?encoding='utf8',?method='xml')


data_dict?=?dict(xmltodict.parse(xmlstr))

print(data_dict)

with?open('new_data_2.json',?'w+')?as?json_file:
????json.dump(data_dict,?json_file,?indent=4,?sort_keys=True)