How can I fix a data frame so that it has more than one row?

Asked Sep 14 '19 at 19:11

Active Sep 14 '19 at 19:11

Viewed 30 times

I have a list with words and the frequency of these, I want to convert that list to a dataframe. but with my code I get a dataframe of 1 row * 901 columns. I would like to know how I could do it to have more than one row and two columns that calls 'Word', 'Frequency'. Thank you!

Music={}
for words in frequency_list:
    Music[words]=frequency[words]
    print(Music)


df = DataFrame(Music, dtype='str', index=[0 ])

print (df)

I expect a data frame with many rows and two columns, but the actual output is [1 rows x 901 columns].

asked Sep 14 '19 at 19:11

N99

2

Possible duplicate of [Convert Python dict into a dataframe](https://stackoverflow.com/questions/18837262/convert-python-dict-into-a-dataframe) – Anoop R Desai Sep 14 '19 at 19:16
2

Try: `df = DataFrame(list(Music.items()), columns=['Word', 'Frequency'])` – Anoop R Desai Sep 14 '19 at 19:19

How can I fix a data frame so that it has more than one row?

0 Answers0