pandas 字符串拼接问题

import pandas as pd
df = pd.DataFrame(columns = ['a', 'b', 'c'],
             data=[['A','1','http:1'],
                   ['B', '2','http:2'],
                   ['C', '3','http:3'],
                   ['D','4','http:4']])
print(df)

   a  b       c
0  A  1  http:1
1  B  2  http:2
2  C  3  http:3
3  D  4  http:4

我想输出：

#Result
G "A","1"
http:1
G "B","2"
http:2
G "C","3"
http:3
G "D","4"
http:4

这样的格式，应该怎么拼接输出啊

pandas

拼接

dataframe

6 replies • 2022-01-21 16:55:28 +08:00

tfdetang

Jan 21, 2022

这不就是行循环一下把每列的内容放到格式化的字符串里就行了吗

toyst

Jan 21, 2022

@tfdetang 关键是这个 http:1 是个回车怎么拼接啊

zhusimaji

Jan 21, 2022 via iPhone

@toyst 回车自己加个\n

cclin

Jan 21, 2022 via Android

拿去抄吧
def combine(line: pd.Series):
print(line)
return f'G "{line.a}","{line.b}"\n{line.c}'

df = df.apply(combine, axis=1)

for s in list(df):
print(s)

cassidyhere

Jan 21, 2022

'G "' + df.a + '","' + df.b + '"\n' + df.c

toyst

Jan 21, 2022

感谢大家，原来输出到文本\n 就能显示换行符了