我正在将CSV文件读入数据帧.CSV文件有一个用于不同锦标赛的组标题行.我想将这个副标题行分离到它自己的列中.稍后我将使用此行中的数据进行分析,以查看结果是否因特定的锦标赛地区而异.如何才能将副标题移到它自己的行中.我认为这将涉及到对各行进行迭代.
因此,数据如下所示
date | P1 | P2 |
---|---|---|
USA Hamersely M45 | NaN | NaN |
22nd Jul 2023,\n04:00 EDT | 1.75 | 56% |
22nd Jul 2023,\n05:00 EDT | 1.85 | 76% |
Canada Valley Y67 | NaN | NaN |
22nd Jul 2023,\n19:00 EDT | 2.37 | 26% |
22nd Jul 2023,\n20:00 EDT | 1.97 | 86% |
22nd Jul 2023,\n22:00 EDT | 1.75 | 96% |
我想把这个换成
Tournament | date | P1 | P2 |
---|---|---|---|
USA Hamersely M45 | 2023/07/22 | 1.75 | 56% |
USA Hamersely M45 | 2023/07/22 | 1.85 | 76% |
Canada Valley Y67 | 2023/07/22 | 2.37 | 26% |
Canada Valley Y67 | 2023/07/22 | 1.97 | 86% |
Canada Valley Y67 | 2023/07/22 | 1.75 | 96% |
import pandas as pd
import numpy as np
data = {
"Date":['USA Hamersely M45','22nd Jul 2023,\n04:00 EDT','22nd Jul 2023,\n05:00 EDT','Canada Valley Y67','22nd Jul 2023,\n04:00 EDT','22nd Jul 2023,\n05:00 EDT','22nd Jul 2023,\n22:00 EDT'],
"p1": [np.nan, 1.75, 1.85, np.nan,2.37,1.97,1.75],
"p2": [np.nan, '56%' , '76%', np.nan,'26%','86%','96%']
}
#load data into a DataFrame object:
df = pd.DataFrame(data)
df.head()```