Reading Excel Files in Python & Display on Screen | Read any Excel File #python #coding #programming

Reading Excel Files in Python & Display on Screen | Read any Excel File #python #coding #programming
One can retrieve information from a spreadsheet. Reading, writing, or modifying the data can be done in Python using different methods. Also, the user might have to go through various sheets and retrieve data based on some criteria or modify some rows and columns and do a lot of work. We will first import the Pandas module then we will use Pandas to read our excel file.

The excel file used in the example contains a list of top cricket players with their country that they represent along with ODI Player Rankings as follows:
PLAYER TEAM RATING
Shubman Gill IND 826
Babar Azam   PAK 824
Virat Kohli IND 791
Rohit Sharma IND 769
Quinton de Kock SA 760
Daryl Mitchell NZ 750
David Warner AUS 745
Rassie Dussen SA 735
Harry Tector   IRE 729
Dawid Malan ENG 729

To import an Excel file into Python using Pandas:

import pandas as pd

print(df)
And if you have a specific Excel sheet that you’d like to import, you may then apply:

import pandas as pd

print(df)

Install the required packages
If you haven’t already done so, install the Pandas and Openpyxl packages.

To install Pandas use:

pip install pandas

To install Openpyxl use:

pip install openpyxl

[SabjiGaming-fevh]

Bhai thanks yar mai openpyxl se kar rha tha dimag kharab ho gaya thanks reel banane ke liye aisa aur rakhe ho to bata dena badhiya damdaar content brothe

But kohli wali baat pe meri abhi bhi sulag rhi