在panda中的每一行中插入一个数据帧

Question

但有人能帮我吗？那太好了。

我有一个这样的数据帧：

Date        Day      Month            
0    2020-01-01  Wednesday   1
1    2020-01-02  Thursday    1
2    2020-01-03  Friday  1
5    2020-01-06  Monday  1
6    2020-01-07  Tuesday 1

另一个数据集看起来像：

[W]  Gewerbe     Werktag
0    00:00:00    255.9
1    01:00:00    216.6
2    02:00:00    196.3
3    03:00:00    194.5
4    04:00:00    226.8

我想把它们合并成这样：

Date        Day      Month            Gewerbe
0    2020-01-01  Wednesday   1       00:00:00    255.9
01:00:00    216.6
02:00:00    196.3
03:00:00    194.5
04:00:00    226.8
......................................................

或者这个

Date        Day      Month            Gewerbe
0    2020-01-01  Wednesday   1       00:00:00    255.9
0    2020-01-01  Wednesday   1       01:00:00    216.6
0    2020-01-01  Wednesday   1       02:00:00    196.3
0    2020-01-01  Wednesday   1       03:00:00    194.5
0    2020-01-01  Wednesday   1       04:00:00    226.8
1    2020-01-02  Thursday    1       00:00:00    255.9
1    2020-01-02  Thursday    1       01:00:00    216.6
1    2020-01-02  Thursday    1       02:00:00    196.3
1    2020-01-02  Thursday    1       03:00:00    194.5
1    2020-01-02  Thursday    1       04:00:00    226.8
.......and so on.....

知道怎么解决这个问题吗？谢谢你的帮助。

Answer 1

使用这样的交叉合并：

import pandas as pd
data = [{"index": 0, "Date": "2020-01-01", "Day": "Wednesday", "Month": 1}, 
{"index": 1, "Date": "2020-01-02", "Day": "Thursday", "Month": 1},
{"index": 2, "Date": "2020-01-03", "Day": "Friday", "Month": 1},
{"index": 5, "Date": "2020-01-06", "Day": "Monday", "Month": 1},
{"index": 6, "Date": "2020-01-07", "Day": "Tuesday", "Month": 1}]

data2= [{"Gewerbe": "00:00:00 ", "Werktag": "255.9"},
{"Gewerbe": "01:00:00 ", "Werktag": "216.6"},
{"Gewerbe": "02:00:00 ", "Werktag": "196.3"},
{"Gewerbe": "03:00:00 ", "Werktag": "194.5"},
{"Gewerbe": "04:00:00 ", "Werktag": "226.8"}]
df = pd.DataFrame(data)
df2 = pd.DataFrame(data2)
df = df.set_index('index')

new_dataframe = pd.merge(df, df2, how="cross")