我有這樣的輸入資料框df1:
url_asia_us_emea
https://asia/image
https://asia/location
https://asia/video
我想根據列名復制行,df1并根據列名更改區域。假設對于此示例,我需要以下輸出,因為所有三個區域都在列名中
url_asia_us_emea
https://asia/image
https://asia/location
https://asia/video
https://us/image
https://us/location
https://us/video
https://emea/image
https://emea/location
https://emea/video
uj5u.com熱心網友回復:
你可以這樣做:
list_strings = [ 'us', 'ema', 'fr']
df_orig =pd.read_csv("ack.csv", sep=";")
這是
url
0 https://asia/image
1 https://asia/location
2 https://asia/video
進而
d = []
for element in list_strings:
df =pd.read_csv("ack.csv", sep=";")
df['url'] = df['url'].replace({'asia': str(element)}, regex=True)
d.append(df)
df = pd.concat(d)
DF = pd.concat([df,df_orig])
這導致
index url
0 https://us/image
1 https://us/location
2 https://us/video
3 https://ema/image
4 https://ema/location
5 https://ema/video
6 https://fr/image
7 https://fr/location
8 https://fr/video
9 https://asia/image
10 https://asia/location
11 https://asia/video
?
轉載請註明出處,本文鏈接:https://www.uj5u.com/qukuanlian/370810.html
