panda stands for ‘panel data’ . Basically panda is a fast, powerful, flexible, easy, open source python library which is used to written for the python programming language for data manipulation and analysis too. In panda it is easy to use data structures and data analysis tools for the python language. As it is open source library it means that anyone can view it’s source code and make suggestions using pull requests.

--

--

xlrd module is used to extract data from a spreadsheet. xlrd has explicitly removed support for reading xlsx sheets.

To read an excel file in python , we will use xlrd module to retrieve information from a spreadsheet. The command need to be installed is xlrd module . xlrd module is used to extract data from a spreadsheet.

Example -

import xlrd location = “C:\\Users\\ \\Documents\\demo.xlsx”

wb = xlrd.open_workbook(location)

sheet = wb.sheet_by_index(0)

print(sheet.cell_value(0, 0))

To write to an excel file in Python, we can use xlsx module and we can perform multiple operations on the spreadsheet, also we can modify the data on python. The command need to be installed is xlsxwriter modul .

Using xlrd module anyone can retrieve information from spreadsheet

--

--

Decorators are a significant part of Python. In simple words: they are functions which modify the functionality of other functions. They help to make our code shorter and more Pythonic.

Decorators are callable objects which are used to modify functions or classes.

Function decorators are functions which accepts function references as arguments and adds a wrapper around them and returns the function with the wrapper as a new function.

Python decorators are also called as metaprogramming because it tries to modify another part of the program at compile time.

There are two types of decorators in Python .

  1. Class Decorator 2. Function Decorator

--

--