通过for循环将DataFrame附加或连接到现有DataFram

Question

在输出中，您将看到此代码获取Location列（或序列），并将其放置在数据帧中。之后，嵌套for循环的第一、第二和第三部分将获取每列的第一个索引，然后创建一个要添加到第一个数据帧的数据帧。我一直在尝试的是for循环，为每个for循环增加一个索引，然后添加一个重复数据的新数据帧。但是，当我试图打印它时，dataframe将只打印第一个dataframe，以及它循环通过的最后一个重复的dataframe。然而，我试图制作一个巨大的数据帧，附加一个从0到17的重复索引数据帧。我已经更新了这个，以显示重复性，我正在寻找，但在一个截断的方式。我希望这有帮助。谢谢！你知道吗

这是输入

    for j in range(0,18,1):
        for i in range(0,18,1):
            df['Rep Loc'] = str(df['Location'][j:j+1])
            df['Rep Lat'] = float(df['Latitude'][j:j+1])
            df['Rep Long'] = float(df['Longitude'][j:j+1])
            break
print(df)

这是输出

                                             Location   Latitude  
Longitude  \
    0   Letsholathebe II Rd, Maun, North-West District... -19.989491  
    23.397709   
    1                       North-West District, Botswana -19.389353  
    23.267951   
    2       Silobela, Kwekwe, Midlands Province, Zimbabwe -18.993930  
    29.147992   
    3   Mosi-Oa-Tunya, Livingstone, Southern Province,... -17.910147  
    25.861904   
    4   Parkway Drive, Victoria Falls, Matabeleland No... -17.909231  
    25.827019   
    5          A33, Kasane, North-West District, Botswana -17.795057  
    25.197270   
    6                       T1, Southern Province, Zambia -17.040664  
    26.608454   
    7   Sikoongo Road, Siavonga, Southern Province, Za... -16.536204  
    28.708753   
    8                 New Kasama, Lusaka Province, Zambia -15.471934  
    28.398588   
    9   Simon Mwansa Kapwepwe Avenue, Avondale, Lusaka... -15.386244  
    28.397111   
    10              Lusaka, Lusaka Province, 1010, Zambia -15.416697  
    28.281381   
    11  Chigwirizano Road, Rhodes Park, Lusaka, Lusaka... -15.401848  
    28.302248   
    12                T2, Kabwe, Central Province, Zambia -14.420744  
    28.462169   
    13   Kabushi Road, Ndola, Copperbelt Province, Zambia -12.997968  
    28.608536   
    14  Dr Aggrey Avenue, Mishenshi, Kitwe, Copperbelt... -12.797684  
    28.199061   
    15  President Avenue, Kalulushi, Copperbelt Provin... -12.833375  
    28.108370   
    16  Eglise Methodiste Unie, Avenue Mantola, Mawawa... -11.699407  
    27.500234   
    17  Avenue Babemba, Kolwezi, Lwalaba, Katanga, Lua... -10.698109  
    25.503816   

                                              Rep Loc    Rep Lat   
    Rep 
    Long  
    0   0    Letsholathebe II Rd, Maun, North-West Dis... -19.989491  
    23.397709  
    1   0    Letsholathebe II Rd, Maun, North-West Dis... -19.989491  
    23.397709  
    2   0    Letsholathebe II Rd, Maun, North-West Dis... -19.989491  
    23.397709  
                                                  Rep Loc    Rep Lat   

    Rep Long  
    0   1    North-West District, Botswana\nName: Loca... -19.389353  
    23.267951  
    1   1    North-West District, Botswana\nName: Loca... -19.389353  
    23.267951  
    2   1    North-West District, Botswana\nName: Loca... -19.389353  
    23.267951

                                                  Rep Loc   Rep Lat   
    Rep Long  
    0   2    Silobela, Kwekwe, Midlands Province, Zimb... -18.99393  
    29.147992  
    1   2    Silobela, Kwekwe, Midlands Province, Zimb... -18.99393  
    29.147992

                                                  Rep Loc    Rep Lat   
    Rep Long  
    0   3    Mosi-Oa-Tunya, Livingstone, Southern Prov... -17.910147  
    25.861904  
    1   3    Mosi-Oa-Tunya, Livingstone, Southern Prov... -17.910147  
    25.861904  
    2   3    Mosi-Oa-Tunya, Livingstone, Southern Prov... -17.910147  
    25.861904 

                                          Rep Loc    Rep Lat   Rep 
    Long  
    0   4    Parkway Drive, Victoria Falls, Matabelela... -17.909231  
    25.827019  
    1   4    Parkway Drive, Victoria Falls, Matabelela... -17.909231  
    25.827019  
    2   4    Parkway Drive, Victoria Falls, Matabelela... -17.909231  
    25.827019

                                          Rep Loc    Rep Lat  Rep 
    Long  
    0   5    A33, Kasane, North-West District, Botswan... -17.795057  
    25.19727  
    1   5    A33, Kasane, North-West District, Botswan... -17.795057  
    25.19727  
    2   5    A33, Kasane, North-West District, Botswan... -17.795057  
    25.19727

Answer 1

提问时的好做法是提供一个示例，说明您希望输出的内容是什么样的。不过，这是我对你想要的最好的猜测。你知道吗

pd.concat({i: d.shift(i) for i in range(18)}, axis=1)