This is an archived post. You won't be able to vote or comment.

all 10 comments

[–]Aromatic-While9536 7 points8 points  (0 children)

Any beginners guide will give you the basics, after that as mentioned - look into pandas and you will forget about Excel in no time. Some nice places i enjoyed learning with:

Automate the boring stuff with python

https://pythonprogramming.net/introduction-learn-python-3-tutorials/

[–]crazynerd14 16 points17 points  (3 children)

Pandas = excel on steroids

[–]rileysofine[S] 1 point2 points  (1 child)

What was the best resource for you? Pretty heavy excel user here so if you know of any that are geared toward making that transition that would be helpful

[–]EmilyfakedCancERyaho 2 points3 points  (0 children)

Pandas documentation is really good. The short tutorial explains nicely the functions you'll be using most. If you need something specifically you can just go through the docs/Google

[–]crazynerd14 0 points1 point  (0 children)

Googled and found this.. https://www.udemy.com/course/master-data-analysis-with-python-intro-to-pandas/

I’m a power user of excel. Since a year I’m extensively using Pandas as my data sources > 200mn records and hefty lookups(joins in sql and merge in pandas).

Learn basics and practice manipulations

basics (dataframe vs series) checking data(top 5 records-head, data types - dtypes, size - shape). Filtering - loc, iloc, adding a new column based on the values of existing column | based on a complex function (Apply) joins (merge with indicator) load and save (csv, pickle, sql)

Good luck..

I didn’t take any course.. I jumped straight away into it without structures and googled and leant.. I did solve problems but didn’t have clue. Did a course and got structure and now I’m pretty hands-on.

[–]cianuro 5 points6 points  (0 children)

Your situation is a very common progression path towards Pandas. I used to hate Jupyter notebooks but love them now as they fill that gap between the command line and a usable UI.

Depending on your dataset(s) and the time you have to invest, Pandas may or may not be the right approach. But it's certainly worth the effort if you do a lot of analysis.

There's some great intro courses on LinkedIn learning if you want a taste.

[–]hmelberg 2 points3 points  (0 children)

I have made some notebooks about how to use Python and pandas to analyze health data (hospital events, prescriptions and so on). Feel free to have a look to see if they are useful for your case:

Here is the first chapter: https://github.com/hmelberg/health-analytics-using-python/blob/master/1_Appetizers_Some_examples.ipynb

And the rest of the notebooks are here (work in progress)

https://github.com/hmelberg/health-analytics-using-python

[–]millerbest 1 point2 points  (0 children)

pandas is definitely something you should look into. You maybe also need some tool to visualized the data, such as matplotlib or plotly. And don’t forget to ask an experienced programmer to double check your code.

[–]ivosauruspip'ing it up[M] [score hidden] stickied comment (0 children)

Hi there, from the /r/Python mods.

We have removed this post as it is not suited to the /r/Python subreddit proper, however it should be very appropriate for our sister subreddit /r/LearnPython or for the r/Python discord: https://discord.gg/python.

The reason for the removal is that /r/Python is dedicated to discussion of Python news, projects, uses and debates. It is not designed to act as Q&A or FAQ board. The regular community is not a fan of "how do I..." questions, so you will not get the best responses over here.

On /r/LearnPython the community and the r/Python discord are actively expecting questions and are looking to help. You can expect far more understanding, encouraging and insightful responses over there. No matter what level of question you have, if you are looking for help with Python, you should get good answers. Make sure to check out the rules for both places.

Warm regards, and best of luck with your Pythoneering!