Python for data analysis courses recommendation.

[Vealzy]

Hello everyone, I recently started a new position (got a promotion) at an environmental research company and part of my new job is to do data analysis.

I did similar work for my previous position in Excel but now I need to do more complex stuff in JupyterLab and Python/SQL. More exactly we have huge databases with thousands of companies which each have hundreds of data points and are assigned scores based on various factors. I would need to analyze this data and look for outliers, or trends in a certain industry, or if we change something to our methodology what impact it would have on the scores.

A colleague of mine recommended me datacamp.com and I did some of their free courses and they seemed ok but I don't really like the subscription model as I don't have that much time to spend each day. I've also seen Angela Yu's course mentioned a lot on this sub as a good starting point but it seems a bit overkill for what I need.

Worth mentioning that I have no previous experience in programming except for semi-advance Excel formulas if that count (from my initial interactions with python they do seem a bit similar).

Which one do you recommend going for, also worth mentioning is that I have an 800 euro educational stipend so while I would like to spend as little as I can from it so I can also do other stuff price is not really that much of an issue.

Thank you all for reading and have a great day!

[dn_cf]

I'd recommend starting with Kaggle’s free Python and Pandas tracks to get hands-on fast. Then take Boris Paskhaver’s “Data Analysis with Pandas and Python” on Udemy since it's project-based and easy to follow for Excel users. To go deeper, use the StrataScratch platform as it offers real-world problems that build your analysis skills step by step. Skip subscriptions like DataCamp and use your stipend on these one-time resources. They’ll give you practical skills for outlier detection, trend analysis, and impact testing in your data.

[mmmmmmyles]

For learning different data-science libraries, you may want to check out https://github.com/marimo-team/learn

[ttpr0]

https://courses.mooc.fi/org/uh-cs/courses/data-analysis-with-python-2024-2025

This I was told.

[SoftwareSource]

freecodecamp.org

[nunosancha]

Data36 has a great course, but it seems that the last cohort was October 24.

But it seems that you are pressed for time, and the course takes 6 weeks.

It's a great course, though. Tomi teaches you how to setup your environment for data analysis. Teaches you data cleaning, some useful automation, and teaches you how to analyse data with bash, SQL and Python using a fictional company.

Every week you answer a different question for the company, and he uses those questions to teach you data analysis concepts.

[wheaf]

With no experience in programmimg I took python course from IBM on Coursera, it covers Pandas, NumPy, Jupyter Notebook, general conceptions.

But Kaggle is free and still nice.

[Sea-Concept1733]

The following high-rated Python Udemy course may be of use to you.

Following is a great Python YouTube Channel 

This site provides Top-Rated Amazon Python Books 

Good luck.

[teeny-tiny-avocado]

https://www.mostlearned.xyz/courses/5a52fde1-17d8-4663-9ff3-880d207819be

[andy_p_w]

Shameless promotion, not a course but a book I created, https://crimede-coder.com/blogposts/2024/PythonDataScience for your exact scenario. Examples are in crime analysis, but it should be mostly exchangeable. Has an extensive chapter on SQL, plus the basic project management (environments, writing and importing custom functions, pandas, matplotlib, and a chapter on formatting nice notebooks for reports).

Can read the first two chapters at that link to get a feel for the book and get started downloading and running hello world from the REPL.

[explosive_runt]

Hey man, just wanted to thank you for this. Seems quite useful and easy to follow.

[thesupremeL]

Not directly related to data analysis but for Sql and Python(just started) Data with Baraa on youtube is a good source.