如何利用Python程序对爬取的数据进行数据清洗和整理

Question

https://vip.stock.finance.sina.com.cn/forex/api/jsonp.php/var%20_fx_seurusd_30_1660029973800=/NewForexService.getMinKline?symbol=fx_seurusd&scale=30&datalen=240

如何把它处理pandas格式

Answer 1

# -*- coding: UTF-8 -*-
"""
@项目名称：如何利用Python程序对爬取的数据进行数据清洗和整理_7769899.py
@作   者：陆地起飞全靠浪
@创建日期：2022-08-09-15:49
"""
fx_seurusd_30_1660029973800 = [
    {"d": "2022-08-02 19:00:00", "o": "1.02339", "l": "1.02200", "h": "1.02373", "c": "1.02270"},
    {"d": "2022-08-02 19:30:00", "o": "1.02269", "l": "1.02220", "h": "1.02428", "c": "1.02379"},
    {"d": "2022-08-02 20:00:00", "o": "1.02379", "l": "1.02170", "h": "1.02410", "c": "1.02236"},
    {"d": "2022-08-02 20:30:00", "o": "1.02237", "l": "1.02080", "h": "1.02328", "c": "1.02166"},
    {"d": "2022-08-02 21:00:00", "o": "1.02164", "l": "1.02050", "h": "1.02186", "c": "1.02118"},
   
    {"d": "2022-08-09 16:00:00", "o": "1.02015", "l": "1.01990", "h": "1.02097", "c": "1.02072"}]
import pandas as pd
df_data = [[x["d"],x["o"],x["l"],x["h"]]for x in fx_seurusd_30_1660029973800]
df_data = [["d","o","l","h"]]+df_data
g_variPandasDfFpx = pd.DataFrame(df_data)

g_variPandasDfFpx.to_csv(r'./g_variPandasDfxq.csv', encoding='GBK')