- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to convert a spreadsheet to Python dictionary?
The easiest way to convert a spreadsheet to Python dictionary is to use an external library like pandas. This provides very helpful features like to_dict on excel objects. You can use these like −
Example
from pandas import *
xls = ExcelFile('my_file.xls')
data = xls.parse(xls.sheet_names[0])
print(data.to_dict())Output
This will give the output −
{'id': 10, 'name': "John"}
Updated on 05-Mar-2020 06:49:21
- Related Questions & Answers
- How to convert Javascript dictionary to Python dictionary?
- How to convert Python Dictionary to a list?
- How to convert a string to dictionary in Python?
- Convert string dictionary to dictionary in Python
- How to convert a String representation of a Dictionary to a dictionary in Python?
- How to convert the string representation of a dictionary to a dictionary in python?
- How to convert list to dictionary in Python?
- How to convert Python dictionary keys/values to lowercase?
- How can I convert a Python Named tuple to a dictionary?
- Python - Convert a set into dictionary
- How to define a Python dictionary within dictionary?
- Python for Spreadsheet Users
- Python - Convert flattened dictionary into nested dictionary
- Python Convert nested dictionary into flattened dictionary?
- Python program to convert a list of tuples into Dictionary
Advertisements