python空气质量_python基础学习之空气质量可视化（六）数据可视化

本次使用jupyter lab 进行数据可视化

import pandas as pd

from pyecharts.globals import CurrentConfig, NotebookType

CurrentConfig.NOTEBOOK_TYPE = NotebookType.JUPYTER_LAB

import pyecharts.options as opts

from pyecharts.globals import ThemeType

from pyecharts.charts import Parallel

import pymysql

导入数据

conn = pymysql.connect(

host=“127.0.0.1”,

port=3306,

user=“root”,

password=“root”,

database=“chai”,

)

qu_sql = “select *from aq”

data= pd.read_sql_query(qu_sql, conn)

data = df[(df[‘year’] == (‘2019’))]

df_final = data[[‘AQI’, ‘PM2’, ‘PM10’,‘SO2’,‘CO’,‘NO2’,‘O3’,‘grade’]].values.tolist()

关闭链接

conn.close()

parallel = (

Parallel(init_opts=opts.InitOpts(theme=ThemeType.DARK))

.add_schema(

[

opts.ParallelAxisOpts(dim=0, name=“AQI”),

opts.ParallelAxisOpts(dim=1, name=“PM2”),

opts.ParallelAxisOpts(dim=2, name=“PM10”),

opts.ParallelAxisOpts(dim=3, name=“SO2”),

opts.ParallelAxisOpts(dim=4, name=“CO”),

opts.ParallelAxisOpts(dim=5, name=“NO2”),

opts.ParallelAxisOpts(dim=6, name=“O3”),

#opts.ParallelAxisOpts(dim=5, name=“PM10”),

opts.ParallelAxisOpts(

dim=7,

name=“grade”,

type_=“category”,

data=[“优”, “良”, “轻度污染”, “中度污染”, “重度污染”, “严重污染”],

),

]

)

.add(“2019年郑州”, df_final[:365])

.set_global_opts(title_opts=opts.TitleOpts(title=“郑州19年空气质量平行折线图”))

)

parallel.load_javascript()

parallel.render_notebook()

parallel.render(‘郑州空气质量平行折线图.html’)

#AQI走势图

import pandas as pd

from pyecharts.globals import CurrentConfig, NotebookType

CurrentConfig.NOTEBOOK_TYPE = NotebookType.JUPYTER_LAB

import pyecharts.options as opts

from pyecharts.globals import ThemeType

from pyecharts.charts import Parallel

from pyecharts.