Python vs. Excel for 7 Data Analysis Tasks

Both Python and Microsoft Excel are widely used tools for data analysis. What are the main differences between them?
This video is a short overview of the top seven most common tasks in data analysis. In this video, I will show you how to do each of these tasks in both Microsoft Excel and in Python using the Pandas library.
Edlitera article on the 7 most common tasks in data analysis: www.edlitera.c...
#pandas #python #dataanalysis #excel
(01:16) Top 7 Most Common Tasks in Data Analysis
(02:05) Looking At and Representing Data
(06:24) Selecting Data
(09:52) Sorting Data
(11:20) Filtering Data
(13:10) Subtracting Data
(15:27) Merging Datasets
(25:13) Pivoting Data
(29:11) Bonus: Two Cool Things
If you are new to Jupyter notebooks, here are a few videos you might find useful:
1. How to Open a Jupyter Notebook: • How to Open a Jupyter ...
2. How Python works in Jupyter Notebook: • How Python Works in Ju...
3. When to Use a Jupyter Notebook: • When to NOT Use a Jupy...
4. Cell Types in Jupyter Notebook: • Code, Markdown, Raw NB...
5. How to Use Markdown in Jupyter Notebook: • How to Use Markdown in...
Edlitera provides on-demand and live online training in programming, data science, data analysis, and data engineering.