如何将两行组合成一只熊猫

Question

我有系列

    1 Lycan-Ogre Magi-Bloodseeker-Zeus-Tiny-WIN
    2 Tidehunter-Spectre-Warlock-Razor-Marci-LOSE
    3 Spectre-Enigma-Dazzle-Razor-Tiny-WIN
    4 Medusa-Hoodwink-Tusk-Beastmaster-Enchantress-LOSE

我希望是这样

1 Lycan-Ogre Magi-Bloodseeker-Zeus-Tiny-WIN | Tidehunter-Spectre-Warlock-Razor-Marci-LOSE
2 Spectre-Enigma-Dazzle-Razor-Tiny-WIN | Medusa-Hoodwink-Tusk-Beastmaster-Enchantress-LOSE

Answer 1

您可以通过由整数除法由join创建的助手数组聚合2。

print (df)
                                                 col
1          Lycan-Ogre Magi-Bloodseeker-Zeus-Tiny-WIN
2        Tidehunter-Spectre-Warlock-Razor-Marci-LOSE
3               Spectre-Enigma-Dazzle-Razor-Tiny-WIN
4  Medusa-Hoodwink-Tusk-Beastmaster-Enchantress-LOSE

df = (df.groupby(np.arange(len(df.index)) // 2)['col']
        .agg(' | '.join)
        .reset_index(drop=True)
        .to_frame())
print (df)
                                                 col
0  Lycan-Ogre Magi-Bloodseeker-Zeus-Tiny-WIN | Ti...
1  Spectre-Enigma-Dazzle-Razor-Tiny-WIN | Medusa-...