/Python/How to apply 1nf dataframe in python

How to apply 1nf dataframe in python

01
02
03
04
05
06
07
08
09
10
11
12
import pandas as pd
import numpy as np
 
df = pd.DataFrame({'Name': ['David', 'Glenn', 'Steve'], 'Subjects': [
                  ['English', 'Math'], ['Math'], ['Science', 'English']]})
 
lens = list(map(len, df['Subjects'].values))
 
res = pd.DataFrame({'Name': np.repeat(
    df['Name'], lens), 'Subject': np.concatenate(df['Subjects'].values)})
 
print(res)

Source: pythonpool.com

Similar codes

3 votes249 views1 answer
How to check for a particular word in a text file using python
Python
-1 vote327 views2 answers
How to url encode using python django
Python Django
0 vote303 views1 answer
Django-multivaluedictkeyerror-error
Python Django
0 vote291 views1 answer
Pandas boolean array calculating the average of a column based on another column filter
Python
0 vote274 views2 answers
Python thousands separators
Python
1 vote221 views1 answer
How to get response code from requests python
Python
8 votes307 views3 answers
Export multiple python pandas dataframe to single excel file
Python
0 vote285 views1 answer
Plt clor image histogram
Python
0 vote267 views1 answer
Speak by a discord bot in python
Python
1 vote265 views1 answer
Brz: ERROR: TypeError: a bytes-like object is required, not 'str'
Python