Excel file to dictionary

Question

I have an excel file which contains 2 columns and I want to convert these columns to the dictionary using the header as key and rows as values.

file1.xlxs

name      price
Merry     5000
John      6500
Nat       4800

The dictionary should be like this:

List1 =  {'name':['Merry,John,Nat'],'price':['5000,6500,4800']}

Please help?

Using Pandas we can do it. Check out this answer-https://stackoverflow.com/a/16896091/6561141 — tpk, Oct 17 '18 at 07:10

score 0 · Accepted Answer · answered Oct 17 '18 at 07:14

0

Use pandas library for this

import pandas as pd

df = pd.read_excel("path to your excel file")

list1 = df.to_dict(orient='list')

Here is documentation for df.to_dict

answered Oct 17 '18 at 07:14

Sociopath

1 Answers1