我会这样做

import pandas as pd

data = [['Oregon', [u'Eugen', u'Portland']], ['New York', [u'New Jersey', u'Buffalo']], ['Utah', [u'Salt Lake City']],['Texas', None]]
df=pd.DataFrame(data, columns=['States', 'Cities'])

这给出了

States      Cities
0   Oregon      [Eugen, Portland]
1   New York    [New Jersey, Buffalo]
2   Utah        [Salt Lake City]
3   Texas       None

然后操作一个副本，首先去掉none，然后生成字符串

df1 = df.copy()
df1 = df1.dropna()
df1['Cities'] = df1['Cities'].apply("','".join)
df1['Cities'] = "'" + df1['Cities'] + "'"
df1

这给了

States      Cities
0   Oregon      'Eugen','Portland'
1   New York    'New Jersey','Buffalo'
2   Utah        'Salt Lake CIty'

import pandas as pd

    # sample data
    df = pd.DataFrame({'col1': [1, 2, 3], 'col2': [[4, 5, 6], [7, 8, 9], [10, 11, 12]]})

    # function to convert list to CSV format
    def list_to_csv(lst):
        return ','.join(map(str, lst))

    # apply function to column containing lists
    df['col2_csv'] = df['col2'].apply(list_to_csv)

    # display the result
    print(df)

输出：
col1 col2 col2_csv
0 1 [4，5，6] 4，5，6
1 2 [7，8，9] 7，8，9
2 3 [10，11，12] 10，11，12