1 回答
TA贡献1966条经验 获得超4个赞
如果您想在其余代码中将它们作为 DataFrame 进行操作,您可以将它们转换ngstor为ngpxDataFrame,如下所示:
import pandas as pd
# I create two lists that look like yours
ngstor = [[1,2], ["2020-04-03", "2020-05-07"]]
ngpx = [[3,4] , ["2020-04-03", "2020-05-07"]]
# I transform them to DataFrames
ngstor = pd.DataFrame({"value1": ngstor[0],
"date_col": ngstor[1]})
ngpx = pd.DataFrame({"value2": ngpx[0],
"date_col": ngpx[1]})
然后您可以使用pandas.merge或pandas.concat:
# merge option
joined_framed = pd.merge(ngstor, ngpx, on="date_col",
how="outer")
# concat option
ngstor = ngstor.set_index("date_col")
ngpx = ngpx.set_index("date_col")
joined_framed = pd.concat([ngstor, ngpx], axis=1,
join="outer").reset_index()
结果将是:
date_col value1 value2
0 2020-04-03 1 3
1 2020-05-07 2 4
添加回答
举报