I have a below nested list,
list = [Language:'Tamil'
Capital: 'Chennai'
Place: 'Chennai', 'Vellore', 'Trichy', 'Madurai'
]
I’m expecting to transpose it as,
Language Capital Place
Tamil Chennai Chennai
Tamil Chennai Vellore
Tamil Chennai Trichy
Tamil Chennai Madurai
Tried converting to pandas dataframe,
df = pd.DataFrame(list)
The result is
Language Capital Place
Tamil Chennai ['Chennai', 'Vellore', 'Trichy', 'Madurai']
Suggestions would be appreciated to transpose each list of values in a new row for the place
3
You can use a list comprehension to flatten the data beforehand:
import pandas as pd
data = {
'Language': 'Tamil',
'Capital': 'Chennai',
'Place': ['Chennai', 'Vellore', 'Trichy', 'Madurai']
}
flattened_data = [
{'Language': data['Language'], 'Capital': data['Capital'], 'Place': place}
for place in data['Place']
]
df = pd.DataFrame(flattened_data)
print(df)
Output:
| index | Language | Capital | Place |
|---|---|---|---|
| 0 | Tamil | Chennai | Chennai |
| 1 | Tamil | Chennai | Vellore |
| 2 | Tamil | Chennai | Trichy |
| 3 | Tamil | Chennai | Madurai |