'''
The i18n module was removed in pygal-2.0.0.
 however, it can now be found in the pygal_maps_world plugin.
You can install that with pip install pygal_maps_world.
Then you can access COUNTRIES as pygal.maps.world.COUNTRIES:
from pygal.maps.world import COUNTRIES
Whats left of the i18n module can be imported with:
from pygal_maps_world import i18n
'''
#獲取兩個字母的國別碼
from pygal_maps_world.i18n import COUNTRIES
def get_country_code(country_name):
    for code,name in COUNTRIES.items():
        if name==country_name:
            return code
        return None

import json
from Country_codes import get_country_code
#提取相關(guān)數(shù)據(jù)
filename='population_data.json'
with open(filename) as f:
    pop_data=json.load(f) #json.load()將數(shù)據(jù)轉(zhuǎn)換為Python能夠處理的格式并存儲在pop_data中
    for pop_dict in pop_data:
        #獲得每個國家2010年的人口數(shù)量
        if pop_dict['Year']=='2010':
            country_name=pop_dict['Country Name']
            population=int(float(pop_dict['Value']))#先將字符串轉(zhuǎn)換為浮點(diǎn)數(shù)，再將浮點(diǎn)數(shù)轉(zhuǎn)換為整數(shù)
            code=get_country_code(country_name)  #獲得國家的國別碼
            if code:
                print(code+':'+str(population))
            else:
                print('ERROR-'+country_name)

import csv
from matplotlib import pyplot as plt
from datetime import datetime
#讀取CSV文件數(shù)據(jù)
filename='sitka_weather_2014.csv'
with open(filename) as f: #打開這個文件，并將結(jié)果文件對象存儲在f中
    reader=csv.reader(f)  #創(chuàng)建一個閱讀器reader
    header_row=next(reader) #返回文件中的下一行
    dates,highs,lows=[],[],[]      #聲明存儲日期，最值的列表
    for row in reader:
        current_date=datetime.strptime(row[0],'%Y-%m-%d')  #將日期數(shù)據(jù)轉(zhuǎn)換為datetime對象
        dates.append(current_date)    #存儲日期
        high=int(row[1])    #將字符串轉(zhuǎn)換為數(shù)字
        highs.append(high)   #存儲溫度最大值
        low=int(row[3])
        lows.append(low)    #存儲溫度最小值

#根據(jù)數(shù)據(jù)繪制圖形
fig=plt.figure(dpi=128,figsize=(10,6))
plt.plot(dates,highs,c='red',alpha=0.5)#實(shí)參alpha指定顏色的透明度，0表示完全透明，1（默認(rèn)值）完全不透明
plt.plot(dates,lows,c='blue',alpha=0.5)
plt.fill_between(dates,highs,lows,facecolor='blue',alpha=0.1) #給圖表區(qū)域填充顏色
plt.title('Daily high and low temperature-2004',fontsize=24)
plt.xlabel('',fontsize=16)
plt.ylabel('Temperature(F)',fontsize=16)
plt.tick_params(axis='both',which='major',labelsize=16)
fig.autofmt_xdate()  #繪制斜的日期標(biāo)簽
plt.show()

'''
The i18n module was removed in pygal-2.0.0.
 however, it can now be found in the pygal_maps_world plugin.
You can install that with pip install pygal_maps_world.
Then you can access COUNTRIES as pygal.maps.world.COUNTRIES:
from pygal.maps.world import COUNTRIES
Whats left of the i18n module can be imported with:
from pygal_maps_world import i18n
'''
#獲取兩個字母的國別碼
from pygal_maps_world.i18n import COUNTRIES
def get_country_code(country_name):
    for code,name in COUNTRIES.items():
        if name==country_name:
            return code
        return None

import json
from Country_codes import get_country_code
#提取相關(guān)數(shù)據(jù)
filename='population_data.json'
with open(filename) as f:
    pop_data=json.load(f) #json.load()將數(shù)據(jù)轉(zhuǎn)換為Python能夠處理的格式并存儲在pop_data中
    for pop_dict in pop_data:
        #獲得每個國家2010年的人口數(shù)量
        if pop_dict['Year']=='2010':
            country_name=pop_dict['Country Name']
            population=int(float(pop_dict['Value']))#先將字符串轉(zhuǎn)換為浮點(diǎn)數(shù)，再將浮點(diǎn)數(shù)轉(zhuǎn)換為整數(shù)
            code=get_country_code(country_name)  #獲得國家的國別碼
            if code:
                print(code+':'+str(population))
            else:
                print('ERROR-'+country_name)

import json

f = open("D:/文件/資料/GT.csv", "r", encoding='GB2312') # csv文件的路徑
data_lines = f.readlines()
f.close()
data_lines.pop(0)

values = []
for line in data_lines:
    line = line.replace("\n", "") 
    values.append(line.split(","))
# print(ls)

# json文件為鍵值對，keys為左側(cè)鍵
keys = ["stamp_sec", "obj_stamp_sec", "frame_num", "source", "id", "track_id", "lane_id", "center_x", "center_y", "center_z", "closest_point_x",
        "closest_point_y", "closest_point_z", "closest_box_x", "closest_box_y", "closest_box_z", "front_bumper_x",
        "front_bumper_y", "front_bumper_z", "rear_bumper_x", "rear_bumper_y", "rear_bumper_z", "move_status", "cut_in", "cut_out",
        "cipv", "velocity_x", "velocity_y", "velocity_z", "project_velocity_x", "project_velocity_y", "project_velocity_z",
        "acceleration_x", "acceleration_y", "acceleration_z", "project_acceleration_x", "project_acceleration_y",
        "project_acceleration_z", "angular_velocity", "obj_yaw", "direction_x", "direction_y", "direction_z", "height", "length",
        "width", "is_radar_matching", "is_tracked", "radar_velocity_x", "radar_velocity_y", "radar_velocity_z", "type",
        "type_confidence", "pose_pos_x", "pose_pos_y", "pose_pos_z", "roll", "pitch", "yaw", "car_twist", "car_acceleration",
        "reserve_score", "reserve_info", "anchor_x", "anchor_y", "anchor_z", "lidar_name"]

fw = open("D:/文件/資料/a.json", "w", encoding='utf-8') # 創(chuàng)建json文件的路徑

# 利用for循環(huán)遍歷，形成鍵值對
dict_re = [dict(zip(keys, row)) for row in values] if values else None 
# print(dict_re)
a = json.dumps(dict_re, indent=4, ensure_ascii=False)
print(a)
fw.write(a)
fw.close()