我有一个示例数据集,它比我的实际数据集小得多,它实际上是一个文本文件,我想将其作为 pandas 表读取并用它做一些事情:
import pandas as pd
d = {
'one': ['title1', 'R2G', 'title2', 'K5G', 'title2','R14G', 'title2','R2T','title3', 'K10C', 'title4', 'W7C', 'title4', 'R2G', 'title5', 'K8C']
}
df = pd.DataFrame(d)
示例数据集如下所示:
df
Out[20]:
one
0 title1
1 R2G
2 title2
3 K5G
4 title2
5 R14G
6 title2
7 R2T
8 title3
9 K10C
10 title4
11 W7C
12 title4
13 R2G
14 title5
15 K8C
我添加了第二列,名为“值”:
df.insert(1,'value','')
df
Out[22]:
one value
0 title1
1 R2G
2 title2
3 K5G
4 title2
5 R14G
6 title2
7 R2T
8 title3
9 K10C
10 title4
11 W7C
12 title4
13 R2G
14 title5
15 K8C
我想要first将每隔一行移动到“值”列:
one value
0 title1 R2G
1 title2 K5G
2 title2 R14G
3 title2 R2T
4 title3 K10C
5 title4 W7C
6 title4 R2G
7 title5 K8C
I then想要按标题名称分组,因为同一标题可能有多个值:
one value
0 title1 R2G
1 title2 K5G, R14G, R2T
2 title3 K10C
3 title4 W7C , R2G
4 title5 K8C
如何才能实现这一目标?