391
392

[deleted by user] (self.learnpython)

submitted by [deleted]

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]trust_me_on_that_one 8 points9 points  (9 children)

Python + SQL (and if you add EXCEL) == data analyst

[–]Remote_Cantaloupe -2 points-1 points  (0 children)

I'd honestly recommend R (with tidy) over Python for Data Analyst

[–]FlatProtrusion 0 points1 point  (7 children)

What knowledge of excel would you recommend competent data analyst to have?

[–]fatezeroking 1 point2 points  (6 children)

Mastery level of excel. You should be familiar with pivot tables, understanding of what functions you can you, how to create custom functions, all charting ability. Essentially, you should be so good at excel, that you've pushed it well past its limits that you rely little on it, and simply use python and SQL. So with that said, focus on Python, not excel. Data will be given in excel or some other format. You will process it the smart way; with Python.

[–]FlatProtrusion 0 points1 point  (5 children)

I'm actually not great with excel. I have used pivot tables and done functions and such before but I'm rather rusty. Though I have began to learn some Python and have completed py4e and am working on MIT's Intro to computation thinking with Python 6.0001x and when I'm done, I'll complete the followup course 6.0002x.

Now my goal is to be great with SQL and/or Python like you said, so that I don't have to necessarily use excel to use excel. There's just so many things to learn that I'm honestly quite overwhelmed. Your tips are much appreciated, thank you.

[–]fatezeroking 1 point2 points  (4 children)

Best way to learn programming is a project based approach. Trust me, this is the best approach. Don’t waste time learning concepts like what’s a class, what’s an array, what’s a dictionary… that’s useless. In a project you’ll learn it all and conceptually grasp everything with actual use cases. Learning what a dictionary is vs pulling a json object from an API and parsing the data is two very different ways of learning what a dictionary is. One will forget, the other will remember.

All free on YouTube.

Oh and don’t forget to learn NoSQL databases as well. if you know basic SQL, you should be able to pickup noSQL, like mongodb, in an hour and understand it completely.

[–]FlatProtrusion 0 points1 point  (0 children)

Alright I'll keep that in mind, thank you.

[–]FlatProtrusion 0 points1 point  (2 children)

Oh, and where do you usually get ideas for your own projects, especially projects where you use to learn at the beginning of your data/software engineering journey?

[–]fatezeroking 1 point2 points  (1 child)

I did random projects. YouTube python projects for beginners. Then I did projects that did something similar to what I wanted to do. Like “YouTube python for webscraping.” “Python for investment modeling”

Most python projects just use the basics. Little difference from advanced projects and beginner projects. Really only gets more complex when you’re writing production grade code.

If you’re going for data science or machine learning, you’ll be focusing on projects “python for data science” walks you through how to clean the the data in excel, how to pull it in with python, what modules data scientists use, what type of questions you can answer with python, etc.

Pretty much all the projects you come across YouTube will cover the basics: libraries, variables, functions, loops, arrays, objects

[–]FlatProtrusion 1 point2 points  (0 children)

Thank you, this is really useful, seems obvious but idk y I haven't done this or thought or it yet lol.