python - 通过使用字符串格式连接两个其他列来创建一个新列

Question

我有以下代码将两列连接成一个新列:

import pandas as pd

d = {
    'name': ['Tomek', 'Jacek', 'Placek'],
    'surname': ['A', 'B', 'C'],
}

df = pd.DataFrame(d)
df['fullname'] = df['name'] + ' ' + df['surname']
print(df)

# output:
#    name surname  fullname
# 0   Tomek       A   Tomek A
# 1   Jacek       B   Jacek B
# 2  Placek       C  Placek C

但是，我需要改用字符串格式:

import pandas as pd

d = {
    'name': ['Tomek', 'Jacek', 'Placek'],
    'surname': ['A', 'B', 'C'],
}

df = pd.DataFrame(d)
df['fullname'] = f"{df['name']} {df['surname']}"
print(df)

但随后的输出是:

#     name surname                                           fullname
# 0   Tomek       A  0     Tomek\n1     Jacek\n2    Placek\nName: n...
# 1   Jacek       B  0     Tomek\n1     Jacek\n2    Placek\nName: n...
# 2  Placek       C  0     Tomek\n1     Jacek\n2    Placek\nName: n...

我怎样才能使用字符串格式并仍然像第一个那样输出？

Answer 1

I need to use string formatting instead

使用zip() 然后列表理解

df['fill_name']=[f"{a} {b}" for a,b in zip(df.name,df.surname)]
print(df)

---

     name surname fill_name
0   Tomek       A   Tomek A
1   Jacek       B   Jacek B
2  Placek       C  Placek C