How can I convert Excel data in tabular data in python by using file handling and function (I want to prepare gdp monitor)

Question

Python

Answer 1

Use this : https://www.pythonexcel.com/

Answer 2

There are few different ways, depends on what you want to do with the data/the format required.

An easy method, would be to use the Pandas library:

import pandas as pd

file = 'example.xlsx'
xl = pd.ExcelFile(file)
df = xl.parse('Sheet1')

As you have the convience of a pandas dataframe to boot. Makes data manipulation/comparisons a sinch.

Another good library is Openpyxl

Answer 3

Prashanth Kumar can you pls send me the code snippet ...

Answer 4

You can use matplotlib/pivot
tables to visualize:

import matplotlib.pyplot as plt

x = df.some_col
y = df.some_val

plt.scatter(x, y)
plt.show()

Or for bar chart:

bc = df.plot.bar(x='label', y='value', rot=0)

Answer 5

Okay thnx

Answer 6

And what about this If want to convert Excel sheets in graph or pi charts