#!/usr/bin/env?python?3.7
#?-*-?coding:utf-8?-*-
import?pandas?as?pd
import?xml.etree.ElementTree?as?ET

def?xml_to_csv（data=“../data/QQ-LocList/LocList.xml“）:
????tree=ET.parse（data）
????root=tree.getroot（）
????result=[]
????for?country?in?root.iter（‘CountryRegion‘）:#country
????????country_name?country_code?=?country.attrib[“Name“]?country.attrib[“Code“]
????????for?state?in?country:#state
????????????try:
????????????????state_name?state_code?=?state.attrib[‘Name‘]?state.attrib[‘Code‘]
????????????except:
????????????????state_name?=?state_code?=?None
????????????for?city?in?state:#city
????????????????city_name?city_code?=?city.attrib[‘Name‘]?city.attrib[‘Code‘]
????????????????result.append（{‘country_name‘:country_name‘country_code‘:country_code
???????????????????????????????‘state_name‘:state_name‘state_code‘:state_code
???????????????????????????????‘city_name‘:city_name‘city_code‘:city_code}）
????result=pd.Dataframe（resultcolumns=[‘country_name‘‘country_code‘‘state_name‘‘state_code‘‘city_name‘‘city_code‘]）
????result.to_csv（‘../output/FSN_fromQQ.csv‘）
????print（“城市數(shù)量有：“result.shape[0]）
????result.drop_duplicates（subset=[‘country_name‘?]?keep=‘first‘?inplace=True）
????print（“國家數(shù)量有：“?result.shape[0]）
????return?0

if?__name__==“__main__“:
????xml_to_csv（）