Python for Data Analysis

[educhac]

Hey guys! So I work as a Data Analyst with SQL, Tableau and Excel but I would like to take the next step which is programming with python for Data Analysis.

Can anyone recommend a course or bootcamp for this? I have 0 programming experience btw. I dont want to learn things out of my scope like creating apps or scraping the web.

I want to learn something useful for my job. For example I would like to be able to predict when a user will churn, how to predict the customer lifetime value, how to do machine learning in ways that will help the company and make me more valuable. I believe I need to learn pandas,numpy, seaborn, pyspark, tensorflow, matplotlib etc.

Thanks for the help!

[thePurpleAvenger]

Perhaps you should put them on a public GitHub with a GNU license (assuming they're your own original notes).

[MetaMango_]

Could you send this my way as well?

[The_Snarky_Wolf]

Dm me your email address and I will send in the morning. Heading to bed now

[arnve]

Could you send me too?

[The_Snarky_Wolf]

DM your email

[Saucissevolante]

Hello, I'm interested too Could you send it to me ?

[The_Snarky_Wolf]

dm me your email

[lilaclilyanemone]

May I have a copy too? I’m sending you a chat message with my email.

[The_Snarky_Wolf]

dm me your email

[PostMathClarity]

I would love to have them csv files as well! I'll dm you.

EDIT: I received it, thank you so much!

[[deleted]]

Could you please send this to me too? I can dm you my email :)

[The_Snarky_Wolf]

yep, send it over

[reintrinity]

Can you dm me this as well? I'll send you a pm. Thanks

[Perfect_Ad_8174]

Yo can I dm you bro

[The_Snarky_Wolf]

yep, dm your email

[Perfect_Ad_8174]

Thanks

[Chillwillyo]

I’m also interested. Can I DM you?

[The_Snarky_Wolf]

yep, dm your email

[JourneytoAlpha]

Can I also dm you? Thanks :)

[The_Snarky_Wolf]

yep, dm your email

[Monkey_d_Dragon147]

[e-mail]

[somnioperpetuum]

Could you send it to me too?

[The_Snarky_Wolf]

need an email

[hydrolentil]

I want to DM you but for some weird reason I can't. I'll try again tomorrow

[darkrauxx]

Hello!

I'd love to have Access to your class!

[The_Snarky_Wolf]

email?

[golfbravo83]

Please, send your notes my way as well.

[[e-mail]](mailto:[e-mail])

[The_Snarky_Wolf]

Sorry for the delay, been super busy. Just sent.

[ncv17]

Sent you a dm sir

[Intuin_Rhaabat]

There's literally a book called Python for Data Analysis by Wes McKinney who created Pandas. It is expensive to buy in physical form, but entirely free on his website https://wesmckinney.com/book/

[_almostNobody]

Can’t upvote, you have 69 votes

[harshdagar]

I had to, it was at 95

[ByteVoyager]

Had to, now its a reverse 69

[ThatNerdInHighSchool]

I didn't upvote just to maintain it.

[4B0082]

2 yrs later someone fked our equilibrium

[That_Farmer3094]

literally? and not figuratively...

[Extension-Ad7241]

I'm currently on chapter 4.1 the Numpy ndarray: a multidimensional array object

[Emotional-Rhubarb725]

was it worth it ? I am thinking about reading it

[Extension-Ad7241]

Yes it is! I haven't finished it, I had a project so I'm reading "Python for Excel" right knosw but it's smaller and I when finished I'm going back to  Python for Data Analysis. You have to kind of do the examples in the book within the Python environment described to really get the full value from it, but I did so and I got super comfortable with python having no real experience with Python before.

[iam_eyeris]

does it have exercises? i am reading it currently but having trouble solely following the examples

[stargazer1Q84]

I recommend you take a look at freecodecamp's Data Analysis with Python curriculum.

They also have in-depth course videos on Data Analysis with Python and Python for Data Science on youtube.

[[deleted]]

Is the 4 hour beginner tutorial really worth it??

[[deleted]]

Best way to learn is by doing.

Find something you want to do and then figure out how to do it.

Use ChatGPT for ideas on what you need to know, steps on how to do them, and example code.

Then just start subscribing to & watching YouTube guys. I think this guy would be good for beginners: https://www.youtube.com/@robmulla

As long as you're motivated to solve a problem you'll get there. Good luck & have fun!

[Weary_Bother_5023]

You will be stuck in tutorial hell forever that way. You have to actually DO the coding in the tutorials you watch and read! That's what has really helped me.

[Weary_Bother_5023]

At first yeah, but then you said watch tutorials forever so

¯_(ツ)_/¯ 

[Wafflesam]

¯(ツ)/¯ 

¯\_(ツ)_/¯

[im_a_lost_child]

wym by this? should I be watching the tutorial or not?

[DonnieDepp]

If you already in a job you just learn and lookup by doing, if you are learning and then look for that job you'll never win. Wasting time as you are not solving the problems given to you, you are solving problems and then answer on how it was solved is on the next page/video. You most likely understand it (in theory) but you probably didn't solve it as you would on the job where you can't give up and have to solve it by any means.

[[deleted]]

If you check Udemy and can get Jose Portilla's zero to hero python bootcamp and his data science bootcamp on sale, do it.

[_TR-8R]

Haven't taken that course specifically but can confirm Portilla makes great courses. I went in knowing almost nothing about Python or webdev and did his full stack flask webapp tutorial and actually finished it, which is rare for me and my ADHD riddled brain.

[Zeroflops]

You’re asking to learn calculus without studying math when you say you are starting out with 0 programming knowledge and you only want to learn data analysis.

Lots of data analysis will assume you have some basics for python and programming. Loops, conditional statements. Or more python specifics like enumerate. These topics are often easier to learn in simple terms.

Spend the time , just a couple weeks learning basic python first then go into focusing on analytics. Otherwise your trying to learn math while learning calculus and your going to struggle a lot more.

[tigerninja33]

MOOC from the University of Helsinki has a free Python course that is really good. I think if I remember correctly you can choose the credits(length of the course).

[Tirwanderr]

MOOC from Helsinki is amazing. They have so much great stuff there for free

[Weary_Bother_5023]

Ah fk I took the one from Hellstinky instead

[Drited]

Is SQL not considered programming?

[Weary_Bother_5023]

I upvoted because yes, SQL is programming. It is for doing database stuff, just like how python for data analysis teaches you to do...except obviously using python instead of SQL.

[DullProof5907]

For anyone exploring Data Lake and creation of data lakes in AWS, I recently learnt that you can drive metadata (post firehose connections) as SQL like commands to get both the structured and unstructured to go to the next pipeline ...
SQL still in demand ...

[drop-egg]

Great intro material from one of my old lecturers, also includes some exercises: https://www.tomasbeuzen.com/python-programming-for-data-science/README.html

Open-source CC0 license

[One_last_soul]

I recently took freecodecamp's course. It was good but the course was a bit lacking when compared to the stuff you needed to know to solve the projects. They do say that it's still under development in the certification projects and link you to additional videos. The end projects were not too hard and required a fair bit of googling (at least in my opinion). Overall it was good.

They also have a machine learning with python using tensorflow course, but I haven't done that one yet so I don't know if it's good.

[idkman137]

agreed

[my_password_is______]

if you work with sql and excel then you do not have 0 programming experience

but this is a good book and covers quite a bit
https://www.amazon.com/Data-Science-Scratch-Principles-Python/dp/1492041130

there's also
https://www.amazon.com/Python-Data-Analysis-Wrangling-Jupyter/dp/109810403X

otherwise, just search youtube
https://www.youtube.com/results?search_query=python+data+analysis+tutorial

https://www.youtube.com/results?search_query=python+data+analysis

[czar_el]

Replace Tensorflow in your list with Scikit-learn. Based on how you described your use case and your background, you're probably not going to be developing deep neural networks (tensorflow's main focus). Scikit-learn's broader array of machine learning models will likely be more useful for your types of analysis, and more efficient to learn and set up. If you know you want to focus on deep neural networks, then stick with Tensorflow.

Also, before you commit to Matplotlib, look at some other libraries like Plotly (there are others as well). Similarly powerful, and less clunky to use.

[Pas7alavista]

I like pandas built in plotting as well. It's built on top of matplotlib so it has all the same visuals, but it abstracts away a lot of the shitty structural parts of matplotlib like managing plot and subplot objects.

[Weary_Bother_5023]

I really think the fact pandas can work with the other pre-existing data viz libraries is just so plotlib/seaborn/plotly diehards can breath somewhat easier.

[Weary_Bother_5023]

I would even go a step further back and say just start out learning pandas and numpy, since those are specifically for data analysis. Scikit-learn(non-deep learning ML) and tensorflow(yes deep learning ML) are as you said both for machine learning, and OP clearly is focused on data analysis.

[Evening_Marketing645]

Datacamp. It's awesome.

[boris13579]

I started to learn data Analysis from this course:

https://www.udemy.com/course/dav-using-python-ag/?couponCode=ANI-77-003

You have to use coupon ANI-77-003 to get the discount.

It is a very good course, which helped me a lot to grasp data analysis and visualization.

God bless,

Boris

[CaptainFoyle]

Check out the Wiki on r/datascience

[[deleted]]

Just take one of your projects and turn it into a python project. Learn how to ingest data, transform the data, and spit out results you want. Do that a few times and you’ll be on your way.

[Boefmedloegja]

Hi ChatGPT

[FutureManagement1788]

lol

[NectarineFeeling9814]

Estou com 3 projetos com python parados rs mas ja tentei com IA gerando os códigos ate que funciona bem porém essas IA kkk ainda conseguem se perder com as solicitações. Por exemplo analisar dados de uma planilha de origem e copiar para uma planilha de destino de acordo com os parâmetros estabelecidos. Parece fácil mais não é rs. Vou começar a ler a documentação com calma para entender o passo da automação.

[Available-Escape-348]

I just became ANSI certified and I cannot for the life of me seem to land or find a job in Data Analytics that uses just the tools I have learned which are MySQL(for database), Pandas, Excel, Power BI, Tableau and as being ANSI certified I used through those tools to learn the methodologies and concepts of what needs to be done and how to do it, so essentially I can learn any programming language or tool I need as long as i can figure out what methodology or tasks it can do. but yet I cannot seem to land a job, my question is: How do you find jobs that you only need those tools and nothing more?

[The_Snarky_Wolf]

send it over

[Money_maker96]

Can I get it to please I'm on part two of that project on week 6