查找列名称并在整个列值中保留某些字符串

Question

我想在csv中设置“status”列的格式，并将字符串保留在逗号（'sometext'，）旁边的单引号中

例如：

输入

如第2行及；3-如果在任何列值中发现多个值，则应使用管道符号（|）连接，例如电话充电器

预期的输出应粘贴在相同的状态列中，如下所示

我的尝试（无效）：

import pandas as pd 
df = pd.read_csv("test projects.csv") 
scol = df.columns.get_loc("Status") 
statusRegex = re.
compile("'\t',"?"'\t',") mo = statusRegex.search (scol.column)

Answer 1

import pandas as pd

# simplified mock data
df = pd.DataFrame(dict(
    value=[23432] * 3,
    Status=[
        [{'product.type': 'Laptop'}],
        [{'product.type': 'Laptop'}, {'product.type': 'Charger'}],
        [{'product.type': 'TV'}, {'product.type': 'Remote'}]
    ]
))

# make a method to do the desired formatting / extration of data
def da_piper(cell):
    """extracts product.type and concatenates with a pipe"""
    vals = [_['product.type'] for _ in cell]  # get only the product.type values
    return '|'.join(vals)  # join them with a pipe

# save to desired column
df['output'] = df['Status'].apply(da_piper)  # apply the method to the Status col

其他帮助：您不需要使用read_excel，因为csv不是excel格式。它是标准格式的逗号分隔值。在这种情况下，您可以这样做：

import pandas as pd
  
# make a method to do the desired formatting / extration of data
def da_piper(cell):
    """extracts product.type and concatenates with a pipe"""
    vals = [_['product.type'] for _ in cell]  # get only the product.type values
    return '|'.join(vals)  # join them with a pipe
    
# read csv to dataframe
df = pd.read_csv("test projects.csv")

# apply method and save to desired column
df['Status'] = df['Status'].apply(da_piper)  # apply the method to the Status col