Thursday, June 11, 2020

How to read excel sheets from file using python

1. The below transaction file has multple sheets in it. Now we are trying to read the Expense sheet name using python padas.

Syntax:

Readsheet= pd.read_excel(r'G:\DatascienceProjects\examples_datasets\transactions.xlsx', sheet_name = 'Expense') # Name of sheet to read from
#pd.read_excel()
Readsheet.head(3) 
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Element wise operation on LIST vs ARRAY

The use of arrays over lists: You can write  vectorised  code on numpy arrays, not on lists, which is  convenient to read and write, and con...

  • Regular Expression
    Write a regular expression that matches any string that starts with one or more ‘1’s, followed by three or more ‘0’s, followed by any numb...
  • Tuples are immutable, But still we can change items
     Tuple is a immutable, but still we can change or append the elements to the list present in the tuples. Example: 
  • Regular Expressions | Grouping
    Regex: Grouping:: Suppose we have textual data with dates in it and we want to extract only the year from the dates. This can be done using ...