Excel automation with python

Count Number of Rows and Columns in an Excel File using Python

*Video Link:-
https://youtu.be/5lsMhfnbDe4

*Details:-
In this tutorial, we open specific excel sheet in dataframe using pandas. then count no. of rows and columns of that DataFrame.

*Coding:-
import pandas as pd
df=open('abc.xlsx', 'sheet name')
rows=df.axes[0]
columns=df.axes[1]

*Hashtags:-
#coding #programming #python #excel #automation #tutorial #learning #online

Computer Coding Class