r/dataanalysis • • Feb 13 '25

Learning!

Post image
1.7k Upvotes

65 comments sorted by

8

u/cli797 Feb 15 '25

My only recommendation. Stick w one program first, then expand. It could be overwhelming and confusing jumping between R and Python. You'll soon realize you'll need a little of SQL, basic statistics and others depending on the path you forge.

https://www.statlearning.com/

You can download free 2nd edition of statistical learning for either r or python.

2

u/chiribumbi Feb 15 '25

I already know R, bought this version on porpuse

3

u/cli797 Feb 15 '25

Cool, good luck

332

u/alexnew655 Feb 14 '25

Management: “yeah the modeling is cool. Can we just see a volume bar chart in Excel?”

109

u/3BettingYourMom Feb 15 '25

Seriously though. I know several cool tools in python but I write everything in sql and inject the data into a dashboard or export to excel. Quicker turn around times compared to trying to use python. Every once in a while I’ll use python within a power bi dashboard but it’s very basic stuff.

38

u/NoWayItsDavid Feb 15 '25

Pssst don't tell all the data science secrets here. I do it the same way.

8

u/Otherwise-Price-5487 Feb 16 '25

I saw a great TikTok from a senior data scientist the other day that essentially said:

"When preparing an analysis for a client, you should utilize every advanced statistical technique that you can to get accurate results. PCA. Correlation Matrices. AB Testing. Bayesian Regression with lagged variable... whatever you need to arrive at the truth. The final product that you deliver to the client though should be incredibly easy to understand"

[He then proceeded to show an example of a project where, based on a simple timeseries graph you would think that XYZ is true. And then shows another simple graph that contradicts XYZ and makes you realize that actually ABC is true]

"This was the results of months worth of work between a team of advanced data analysts. The difference between a Jr. and a Sr. Data Scientist is the capacity to explain incredibly complex, nuanced results to a child"

1

u/3BettingYourMom Feb 16 '25

This is true in literally any industry.

9

u/Dispicableboo Feb 15 '25

Dm me some other “basic stuff” you use to make your work more efficient l, I’m starting out and would appreciate the insight

2

u/OverratedMusic Feb 16 '25

Nowadays with GitHub copilot, doing analysis on a set of data feels kind of like just talking to your data

1

u/3BettingYourMom Feb 16 '25

We can’t feed proprietary sensitive data to co pilot. Plus co pilot is ass cheeks. I still have to write most of my own code.

76

u/Working-Chair-2092 Feb 14 '25

How do you like Python for Data Analysis? I’m getting my Master’s, and i have the digital copy for one of my classes. I haven’t had the chance to take deep dive into yet.

19

u/[deleted] Feb 14 '25

What masters program are you in? I’m looking at some and curious

31

u/Working-Chair-2092 Feb 14 '25

I’m getting my MS in Business Analytics through University of Iowa. I live here, and I liked the program. There are people from all over the country enrolled too.

5

u/FaceglazerSSBU Feb 15 '25

Hey, I’m in MS of Business Analytics here in Oklahoma at a local college. Just started this semester. How long have you been in yours for?

6

u/Working-Chair-2092 Feb 15 '25

Hey. That’s awesome. I’m the exact same. I started with Data Programming in Python. I’m liking it so far. How about you?

4

u/FaceglazerSSBU Feb 15 '25

Oh sick, I’m both excited and nervous for Data Programming next semester. Lol. I’m in two classes right now, Analysis of Business Management and Marketing Analytics. Both are heavy Excel based, which is good for me!

4

u/Working-Chair-2092 Feb 15 '25

Nice. Hopefully I can pick up the pace and take on more classes. I don’t have any programming experience and I haven’t been overwhelmed by this class.

3

u/FaceglazerSSBU Feb 15 '25

Yeah, I took quite the risk taking 2 this semester considering I work 46+ hours per week, plus always on call. But so far it’s been manageable. You got this though, keep pushing, I believe in you!

2

u/Working-Chair-2092 Feb 15 '25

Thanks. You too!

3

u/Hmmook Feb 16 '25

One piece of advice if you’re working on a Masters is to expand as much as you can on the “non-data” subjects (operations/project management/accounting/finance/etc). The job market is not the best, and that’s being optimistic.

I stayed with the company I was at when I started my MBA and my MS in DA and was able to move and get promoted but I’m not sure how things would have panned out if I had to look for a new spot. Just my $.02

1

u/Working-Chair-2092 Feb 16 '25

That’s great advice. Thank you.

6

u/cli797 Feb 15 '25

I got versions 2 and 3 for python for data analysis. Both will get you good at pandas from. A to z. I also bought a book, effective pandas 2 by Matt Harrison was mind blowing

2

u/Odessa_Goodwin Feb 16 '25

Matt Harrison is fantasitc. Just the right amount of "opinionated" data analysis and commentary. I have effective pandas and effective polars and even though I currently work with R, the things I learned about data analysis from him has made me a better R programmer.

1

u/Fearless-Someone Feb 15 '25

Hey where did you find the digital copy from?

4

u/Hmmook Feb 16 '25

coughlibgencough

1

u/Working-Chair-2092 Feb 15 '25

It’s a text book for one of my classes.

44

u/RickSt3r Feb 14 '25

An introduction to statisti learning has a python version as well. But that's one of my favorite resources. I also recommend watching the series it's free on YouTube.

2

u/BigDogg365 Feb 15 '25

DO you have a link for the Youtube series?

22

u/hardy_and_free Feb 16 '25 edited Feb 16 '25

I highly recommend "A Mind For Numbers" by Barbara Oakley. It's more about how to study and become more mathematically minded than giving you formulas, etc. It honestly was an eye-opener for me as someone who didn't "have a mind for numbers" and didn't really know how to study.

Also highly recommend Brandon Foltz and StatQuest for learning stats on YouTube. My masters' degree professors used them as resources. Both break it down to be extremely understandable, but Brandon gives you these wonderful pep talks that speak to the adult learner.

6

u/COOKIEMONSTER-315 Feb 14 '25

I’ve read the O’Reilly one, it’s the best!

6

u/life_is_enjoy Feb 15 '25

Is that a mongoose on the python book?

7

u/PalpitationFine Feb 15 '25

No that's a python

5

u/life_is_enjoy Feb 15 '25

Or actually a python eater.

1

u/Prinzka Feb 15 '25

A shrew with a very fuzzy tail?

18

u/SprinklesFresh5693 Feb 15 '25

The real thing is reading them, and practising, not just buying them though.

2

u/Individual_Pride1423 Feb 14 '25

Nice. Don't have those.

2

u/Cool-Flower5780 Feb 14 '25

Great books!

1

u/SidewinderVR Feb 15 '25

Nice. Solid and practical foundation.

1

u/AdMaximum1516 Feb 15 '25

It’s not! The golden ticket!

1

u/eljefeky Feb 16 '25

I don’t know if you’ve started James et. al, but depending on your math background that one may be quite challenging. IIRC it is written for a graduate-level mathematical background.

1

u/henrybios Apr 14 '25

Might you be thinking of the ESL by Hastie, Tibshirani? I haven’t read ISLR cover to cover but don’t remember seeing any grad level maths.

1

u/eljefeky Apr 14 '25

You seem to be non-American, so graduate-level mathematics definitions likely vary. Either way, it would have been above the mathematical knowledge of OP IIRC.

1

u/susmen15 Feb 16 '25

Hi I want to start learning data science too, I don't have much of a background regarding the matter, but would love to learn. So where can I start

1

u/Mobile-Collection-90 Mar 02 '25

Why? DAs will be entitely replaced in the VERY close future. I have 10 years' experience in the field but don't take my word for it. Leading experts like Joe Reis agree. Heres a recent post in that :post .

1

u/thvnatoss Mar 08 '25

ISLR is the staple book. I use it in my graduate program and I refer back to it often for personal projects— that things is my lifeline

1

u/Historical_Ad6980 Mar 14 '25

IMO
Data Analytic = Excel + SQL + Python + Statistic + R (about visualization)

1

u/wagwanbruv Nov 22 '25

lol the meta part here is kinda perfect for data work: even a “simple” summarization task breaks if the input isn’t clearly defined, same way an analysis pipeline falls apart when requirements are fuzzy. Next time you can treat it like a mini data project and ask folks to paste the raw text, define the goal (tl;dr, themes, sentiment, whatever), and maybe even share format constraints so you’re not trying to summarize… basically air.

1

u/Trick-Interaction396 Feb 15 '25

You don’t need a that. Use this instead.

x = sales_person_lie

print(x)

-12

u/Double_Education_975 Feb 14 '25

How do you learn this from a book?

67

u/chiribumbi Feb 14 '25

By reading it

7

u/osama-bin-dada Feb 14 '25

You’ll never believe this epic life hack!

3

u/Meet_Foot Feb 14 '25

If those kids could read, they’d be very upset.

1

u/Scigu12 Feb 15 '25

You mean the words?

-5

u/sy2xphus Feb 15 '25

They look cool and definitely have information regarding best practices and etc. but it’s always better just to build something and learn in a process I think

6

u/chiribumbi Feb 15 '25

For your information these books comes with practical exercises, which you can follow using github. Furthermore, two of them are code-based books, not just conceptual books. You literally can replicate all the analysis done.

8

u/hellopandant Feb 15 '25

... and they can do that using the books as tools. It isn't a binary choice.

2

u/tkroy69 Feb 16 '25

For beginners the idea of what to build is itself hard to come up with, these books give you insights of the real world so you get ideas and when you build you have solutions in them as well. Reading these books is actually equivalent to learn by building something.

1

u/data_story_teller Feb 16 '25

How do you know how to build though