Handle Excel with python

Well, it's just a matter of looking at this. https://note.nkmk.me/python-pandas-read-excel/

Note that you need to install xlrd as well as pandas.

sample.py


import sys
import pandas as pd 

#XLS file to read
excel_file = sys.argv[1]
print('File name ⇒', sys.argv[1])


if __name__== '__main__':

	file = pd.ExcelFile(excel_file)

	# "parent"Read the sheet
	sheet_df = file.parse("parent")

	for j,series in sheet_df.iterrows():
		
		#Row-by-line processing
		parent_xxx(series)

Recommended Posts

Handle Excel with python
Excel with Python
Handle Excel CSV files with Python
Handle rabbimq with python
Operate Excel with Python (1)
Operate Excel with Python (2)
[Tips] Handle Athena with Python
solver> Link> Solve Excel Solver with python
Create an Excel file with Python3
Let's play with Excel with Python [Beginner]
Easily handle databases with Python (SQLite3)
Excel aggregation with Python pandas Part 1
FizzBuzz with Python3
Scraping with Python
Statistics with python
Scraping with Python
Python with Go
Twilio with Python
Integrate with Python
Play with 2016-Python
AES256 with python
Tested with Python
python starts with ()
with syntax (Python)
Bingo with python
Zundokokiyoshi with python
Microcomputer with Python
Cast with python
Draw Nozomi Sasaki in Excel with python
Quickly create an excel file with Python #python
Excel aggregation with Python pandas Part 2 Variadic
Trying to handle SQLite3 with Python [Note]
[Easy Python] Reading Excel files with openpyxl
Create Excel file with Python + similarity matrix
[Easy Python] Reading Excel files with pandas
Excel table creation with Python [Progress management table]
Serial communication with Python
Zip, unzip with python
Django 1.11 started with Python3.6
Primality test with Python
Socket communication with Python
Data analysis with python 2
Try scraping with Python.
Learning Python with ChemTHEATER 03
Sequential search with Python
"Object-oriented" learning with python
Run Python with VBA
Handling yaml with python
Solve AtCoder 167 with python
Serial communication with python
[Python] Use JSON with Python
Learning Python with ChemTHEATER 05-1
Run prepDE.py with python3
1.1 Getting Started with Python
Collecting tweets with Python
Binarization with OpenCV / Python
Kernel Method with Python
Non-blocking with Python + uWSGI
Posting tweets with python
[Python] How to read excel file with pandas
Drive WebDriver with python