时序数据可视化——散点图法

时序数据可视化——散点图法：

1、安装pyecharts
2、路径 C:\ProgramData\Anaconda3\Scripts
3、命令 pip install pyecharts

例子：

# 散点图
#导入相关库
from pyecharts import options as opts
from pyecharts.charts import Scatter, Page
from pyecharts.globals import SymbolType

import pandas as pd
# 读取文件-stocks.csv，编码格式-gbk
df = pd.read_csv('stocks.csv', encoding='gbk')

# sql_num = "SELECT trade_date,open,close FROM stocks where trade_date>='2020-01-01'order by trade_date asc"
# 将trade_date转换为datetime类型
df_filtered['trade_date'] = pd.to_datetime(df_filtered['trade_date'])  

# 获取满足where条件的属性：trade_date>='2020-01-01'
df_filtered = df[df['trade_date'] >= '2020-01-01'] 

# 排序：order by trade_date asc        df.sort_values(by="sales" , ascending=False) 
df_filtered = df_filtered.sort_values(by='trade_date', ascending=True)  

# 获取绘图数据
x_data = df_filtered['open'].tolist()  
y_data = df_filtered['close'].tolist()  
# 绘制散点图  
scatter = Scatter()  
scatter.add_xaxis(x_data)  
scatter.add_yaxis(  
    series_name="Stock Prices",  
    y_axis=y_data,  
    symbol_size=10,  
    # symbol=SymbolType.ROUND_RECT  # 如果需要显式指定符号类型，可以使用 ROUND_RECT  
)  
scatter.set_global_opts(title_opts=opts.TitleOpts(title="Stock Open vs Close Prices Scatter Plot"))  
  
# 渲染散点图到HTML文件  
scatter.render('scatter_plot.html')