哪惧明天，风高路斜

需求输入import pandas as pdlt = [["A", "F", "K"], ["B", "G", "L"], ["C", "H", "M"], ["D", "I", "N"], ["E", "J", "O"]]df = pd.DataFrame(lt, columns=["C1", "C2", "C3"])print(df) C1 C2 C30 A F K1 B G L2 C H M3 D I N4 E J O输出：仅一列拼接的时候横向 C10 A

文章目录>>> import pandas as pd>>> import numpy as np>>> df = pd.DataFrame({"A":[1,2,3],"B":[2,3,np.nan]})>>> df A B0 1 2.01 2 3.02 3 NaN>>> df.B.isna() # B列的值为nan0 False1 False2 TrueName: B,

文章目录需求示例展开：根据列表展开为多行筛选：将列表中含某个值的行，都筛选出来拼接：将列表拼接成字符串需求pandas df 的某一列是列表的情况下，进行的相关操作示例>>> import pandas as pd >>> df = pd.DataFrame({"A":[1, 2], "B":[["a", "b"], ["c", "d"]]}>>> df A B0 1 [a, b]1 2 [c, d]展开

目标原始表： number Q1 Q2 Q30 1 B0 C0 D01 1 B1 C1 D12 1 B2 C2 D23 1 B3 C3 D3变为：number Q1 Q2 Q30 1 B0 C0 D01 1 B1 C1 D12 1 B2 ...

>>> x=pd.DataFrame({'number': [1,1,2,2], 'Q1': ['B0', 'B1', 'B2', 'B3'], 'Q2': ['C0', 'C1', 'C2', 'C3'], 'Q3': ['D0', 'D1', 'D2', 'D3']},)&...