I have 2 variables
name = ['John','Seen','Sam','Tom','Lisa']
language = ['python','java','C++','javascript']
I want to use pandas to generate a DataFrame in a format similar to the following:
| name | Language |
|---|---|
| John | python |
| John | java |
| John | C++ |
| John | javascript |
| Seen | python |
| Seen | java |
| Seen | C++ |
| Seen | javascript |
| Sam | python |
| Sam | java |
| Sam | C++ |
| Sam | javascript |
Thanks
Use:
from itertools import product
df = pd.DataFrame(product(name,language), columns=['Name','Language'])
You can try:
import pandas as pd
Knowing that: nameList = ['John','Seen','Sam','Tom','Lisa']
and languageList = ['python','java','C++','javascript']
you do:
df=pd.DataFrame({'name':nameList,'language':languageList})
import pandas as pd
name = ['John','Seen','Sam','Tom','Lisa']
language = ['python','java','C++','javascript']
prod=[]
for i in name:
for j in language:
prod.append((i,j))
df=pd.DataFrame(prod, columns=['name','language'])
