<p>您甚至可以直接插入mysql:</p>
<pre><code>import pandas as pd
import mysql.connector
from sqlalchemy import create_engine
result_dict, result_list = {}, []
#collect input
Condition_Name='ID_0.5_365D'
Insert_Date='2021-05-19 00:00:00'
sample_dict=\
{pd.Timestamp('2015-01-02 00:00:00'): {'navi.o_efx': 180.0,
'navi.o_qrvo.o': 180.0,
'navi.o_stm.n': 180.0,
'qrvo.o_efx': 1.0,
'qrvo.o_stm.n': 1.0},
pd.Timestamp('2014-12-31 00:00:00'): {'navi.o_efx': 179.0,
'navi.o_stm.n': 179.0}}
#populate result_dict
for key,value in sample_dict.items():
for item_key, item_value in value.items():
result_dict['condition_name']=Condition_Name
result_dict['insert_date']=Insert_Date
result_dict['date']=key
result_dict['pair_name']=item_key
result_dict['pair_value']=item_value
result_list.append(result_dict.copy())
index_list = range(1, len(result_list)+1)
df1 = pd.DataFrame(result_list, columns = ['index', 'condition_name', 'insert_date', 'date', 'pair_name', 'pair_value'], index= index_list)
#dump into mysql
engine = create_engine('mysql+mysqldb://[user]:[pass]@[host]:[port]/[schema]', echo = False)
df1.to_sql(name = 'my_table', con = engine, if_exists = 'append', index = False)
</code></pre>