Generate a specific DataFrame with pandas

user_14344609 0
Viewed 57

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

pandas python
3 Answers

Use:

from  itertools import product

df = pd.DataFrame(product(name,language), columns=['Name','Language'])
user_29010020

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})
user_151519660 
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'])
user_173316350
Related