3 ms·

Would you know, or can recommend, any good datasets (or practice exercises) using "Jupyter/Python/NumPy/Pandas/Seaborn" for someone with a similar Excel backgro

Would you know, or can recommend, any good datasets (or practice exercises) using "Jupyter/Python/NumPy/Pandas/Seaborn" for someone with a similar Excel background (and basic understanding of Jupyter/Python/Pandas)?

teekert 9y ago
Seaborn has a standard data set (now that I searched it, it is part of scikit I think) [0], however, I think what made learning fast is that I used the same type of data as I did before and had a clear goal. Excel sheets are easily loaded into pandas: import pandas as pd file = pd.read_xlsx('some_excel_file.xlsx') file # Just typing this will display the file as a table in jupyter, after ctrl-enter to execute the code block To plot: import seaborn as sns %matplotlib inline # This makes the plot appear in the notebook instead of in a separate window sns.violinplot(file) Boom, that is it (assuming the Excel file is a number of columns with labels as the top row). [0] http://scikit-learn.org/stable/auto_examples/datasets/plot_iris_dataset.html http://scikit-learn.org/stable/auto_examples/datasets/plot_i...
- Osiris30 9y ago
  Thanks! I also just did a quick google and found the below resources if anyone else is interested http://www.dataschool.io/best-python-pandas-resources/ http://www.dataschool.io/best-python-pandas-resources/ https://www.quora.com/How-do-I-learn-data-analysis-with-Python-via-projects/answer/Karlijn-Willems-1 https://www.quora.com/How-do-I-learn-data-analysis-with-Pyth... https://www.quora.com/What-is-the-best-way-to-learn-algorithmic-trading-in-Python-and-test-out-models https://www.quora.com/What-is-the-best-way-to-learn-algorith...
  - teekert 9y ago
    Such resources are nice, certainly, they give a feel for what can be done. But in my experience you learn when you get your data loaded and start putting together code based on stackoverflow (or other) answers. Not by "dry-reading" someone else's work. There is no moment where you say: "I'll learn X now", there is a moment when X is the best solution to your problem en you start using it... and become an expert before you realize it. Imho. Maybe it's different for you of course. And, I may have been in a nice position where I had a job that started to required X at some point. I realize that. But then maybe you can find a problem of your own (maybe you want to plot the data from your fitness tracker?) I once spend a lot of time plotting the details of my mortgage (cumulative paid, rent, decreasing dept as function of monthly payments), such data is just the result of some input and you make a table out of it yourself (in Excel if you want, in Pandas if you feel comfortable enough).

teekert 9y ago

Seaborn has a standard data set (now that I searched it, it is part of scikit I think) [0], however, I think what made learning fast is that I used the same type of data as I did before and had a clear goal. Excel sheets are easily loaded into pandas: import pandas as pd file = pd.read_xlsx('some_excel_file.xlsx') file # Just typing this will display the file as a table in jupyter, after ctrl-enter to execute the code block To plot: import seaborn as sns %matplotlib inline # This makes the plot appear in the notebook instead of in a separate window sns.violinplot(file) Boom, that is it (assuming the Excel file is a number of columns with labels as the top row). [0] http://scikit-learn.org/stable/auto_examples/datasets/plot_iris_dataset.html http://scikit-learn.org/stable/auto_examples/datasets/plot_i...

Osiris30 9y ago
Thanks! I also just did a quick google and found the below resources if anyone else is interested http://www.dataschool.io/best-python-pandas-resources/ http://www.dataschool.io/best-python-pandas-resources/ https://www.quora.com/How-do-I-learn-data-analysis-with-Python-via-projects/answer/Karlijn-Willems-1 https://www.quora.com/How-do-I-learn-data-analysis-with-Pyth... https://www.quora.com/What-is-the-best-way-to-learn-algorithmic-trading-in-Python-and-test-out-models https://www.quora.com/What-is-the-best-way-to-learn-algorith...
- teekert 9y ago
  Such resources are nice, certainly, they give a feel for what can be done. But in my experience you learn when you get your data loaded and start putting together code based on stackoverflow (or other) answers. Not by "dry-reading" someone else's work. There is no moment where you say: "I'll learn X now", there is a moment when X is the best solution to your problem en you start using it... and become an expert before you realize it. Imho. Maybe it's different for you of course. And, I may have been in a nice position where I had a job that started to required X at some point. I realize that. But then maybe you can find a problem of your own (maybe you want to plot the data from your fitness tracker?) I once spend a lot of time plotting the details of my mortgage (cumulative paid, rent, decreasing dept as function of monthly payments), such data is just the result of some input and you make a table out of it yourself (in Excel if you want, in Pandas if you feel comfortable enough).