ank0409/Ditching-Excel-for-Python

Functionalities in Excel translated to Python

42
/ 100
Emerging

This project helps anyone who regularly manipulates data in Excel to transition their common tasks to Python. You provide your data in an Excel file, and this guide shows you how to use Python (with Pandas and NumPy) to perform calculations, filtering, and transformations, outputting the results back into Excel. It's designed for data analysts, business users, or researchers who want to upgrade their data processing skills beyond spreadsheets.

227 stars. No commits in the last 6 months.

Use this if you are familiar with Excel for data manipulation and want to learn how to perform those same tasks, and more, using Python for greater automation and power.

Not ideal if you are already proficient in Python for data analysis or if your primary goal is advanced data visualization rather than core data transformation.

data-analysis excel-to-python business-intelligence data-transformation spreadsheet-automation
No License Stale 6m No Package No Dependents
Maintenance 0 / 25
Adoption 10 / 25
Maturity 8 / 25
Community 24 / 25

How are scores calculated?

Stars

227

Forks

90

Language

Jupyter Notebook

License

Last pushed

Apr 20, 2021

Commits (30d)

0

Get this data via API

curl "https://pt-edge.onrender.com/api/v1/quality/ml-frameworks/ank0409/Ditching-Excel-for-Python"

Open to everyone — 100 requests/day, no key needed. Get a free key for 1,000/day.