如何将coma分离的值列表选择到单个列中

SELECT 
    SUBSTRING_INDEX(SUBSTRING_INDEX(csv_column, ',', numbers.n), ',', -1) AS value
FROM 
    your_table
JOIN 
    (SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3) numbers
ON 
    CHAR_LENGTH(csv_column) - CHAR_LENGTH(REPLACE(csv_column, ',', '')) >= numbers.n - 1;

SELECT 
    unnest(string_to_array(csv_column, ',')) AS value
FROM 
    your_table;

import pandas as pd

# 假设df是一个DataFrame，其中有一列名为'csv_column'
df = pd.DataFrame({'csv_column': ['apple,banana,cherry', 'dog,cat,horse']})

# 使用str.split()方法拆分CSV列表
df['value'] = df['csv_column'].str.split(',')

# 展开为多个行
df = df.explode('value')
print(df)

const csvList = 'apple,banana,cherry';
const values = csvList.split(',');

console.log(values); // 输出: ['apple', 'banana', 'cherry']

import re

csv_list = 'apple,banana,cherry'
values = re.split(r',\s*', csv_list)

print(values)  # 输出: ['apple', 'banana', 'cherry']

df['value'] = df['csv_column'].str.split(',').apply(lambda x: [item.strip() for item in x])