convert a list in rows of dataframe in one column to simple string

user_11405455 0
Viewed 76

I have a dataframe which has list in one column that I want to convert into a simple string

    id          data_words_nostops
    26561364    [andrographolide, major, labdane, diterpenoid]
    26561979    [dgat, plays, critical, role, hepatic, triglyc]
    26562217    [despite, success, imatinib, inhibiting, bcr]

DESIRED OUTPUT

id          data_words_nostops
26561364    andrographolide, major, labdane, diterpenoid
26561979    dgat, plays, critical, role, hepatic, triglyc
26562217    despite, success, imatinib, inhibiting, bcr
pandas python
4 Answers

Try this :

df['data_words_nostops'] = df['data_words_nostops'].apply(lambda row : ','.join(row))

Complete code :

import pandas as pd
l1 = ['26561364', '26561979', '26562217']
l2 = [['andrographolide', 'major', 'labdane', 'diterpenoid'],['dgat', 'plays', 'critical', 'role', 'hepatic', 'triglyc'],['despite', 'success', 'imatinib', 'inhibiting', 'bcr']]


df = pd.DataFrame(list(zip(l1, l2)), 
               columns =['id', 'data_words_nostops'])
df['data_words_nostops'] = df['data_words_nostops'].apply(lambda row : ','.join(row))

Output :

id  data_words_nostops
0   26561364    andrographolide,major,labdane,diterpenoid
1   26561979    dgat,plays,critical,role,hepatic,triglyc
2   26562217    despite,success,imatinib,inhibiting,bcr
user_100773540 
df["data_words_nostops"] = df.apply(lambda row: row["data_words_nostops"][0], axis=1)
user_117585850

You can use pandas str join for this:

df["data_words_nostops"] = df["data_words_nostops"].str.join(",")

df

      id           data_words_nostops
0   26561364    andrographolide,major,labdane,diterpenoid
1   26561979    dgat,plays,critical,role,hepatic,triglyc
2   26562217    despite,success,imatinib,inhibiting,bcr
user_71757130

I tried the following as well

df_ready['data_words_nostops_Joined'] = df_ready.data_words_nostops.apply(', '.join)
user_114054550
Related