split the words in one column using pandas

Asked Jun 22 '21 at 15:20

Active Jun 22 '21 at 15:57

Viewed 25 times

I have column in my dataset called Injury Information, This column has information such as [ skin tear, burning, fracture]

the data set is like

ID 12434 Injury Information skin tear, burning, fracture

I need the output to be

skin tear
burning
fracture

I have tried these blew code but I could not get the desired result

MedNote = pd.read_csv('ResearchDate.csv')
print( MedNote.head())

#MedNote = MedNote.set_index('Injury Information')

for index, row in MedNote.iterrows():
    
    # Using for loop
   
    for i in MedNote["Injury Information"][index]:
        #for each in i:
            #i.tolist()
             # print(i.str.split(","))
             print(i)

edited Jun 22 '21 at 15:57

asked Jun 22 '21 at 15:20

Fatimah Altuhaifa

Can you provide a clearer example of what is exactly the input and the expected output? – Zeno Dalla Valle Jun 22 '21 at 15:23
Can you describe the layout of your data more clearly, maybe with an example? – DS_London Jun 22 '21 at 15:23
`MedNote['Injury Information'].str.split(',')` – inspectorG4dget Jun 22 '21 at 15:24
the exact input is the column Injury Information, one row of this column has information such as skin tear, burning – Fatimah Altuhaifa Jun 22 '21 at 15:58
it does work but does not work with MedNote['Injury Information'][index].str.split(',') inspectorG4dget – Fatimah Altuhaifa Jun 22 '21 at 16:13

split the words in one column using pandas

0 Answers0