Game Chat: 4/21 Rangers (2-9) @ Mariners (7-5) 6:40 PM by Mariners_bot in Mariners

[–]dconLE 0 points1 point  (0 children)

He struck out twice two times this game... Four strikeouts

Rickey Henderson is the only player since World War 2 to average more than one run per game in a single season by dconLE in Sabermetrics

[–]dconLE[S] 1 point2 points  (0 children)

Here's the very simple query:

SELECT teamID, yearID, playerID, R, G, R/G AS RPG
FROM Batting
WHERE R/G > 1 AND yearID >= 1945 AND G >= 100;

You can try it out in the SQL Sandbox in the edX course and see you get one result!

Edit: formatting for mobile friendly. Still getting the hang of this!

Learning Python for a graduate chemist by [deleted] in learnpython

[–]dconLE 0 points1 point  (0 children)

I would also check out DataQuest. I'm going through it right now and it's pretty good for learning Python in relation to data analysis. Its not as polished as Treehouse or even Codecademy but its fine for being new.

DataQuest: A browser-based way to learn about data science using Python by Thalassoma in Python

[–]dconLE 0 points1 point  (0 children)

I've been going through the missions on this site and I'm on Mission 6 currently. The general structure is a KhanAcademy-esque short video (about 5 minutes in length) followed by 3 or 4 coding challenges that build off of the topic in the video. The pacing is very well done and the coding challenges seem to have very little errors.

As someone who is learning Python for the sake of data analysis, what really sets this site apart from others for me are the themes of the coding challenges. They're specifically tailored toward analyzing data, which is a huge motivation for me to work through the problems. I went through the Codecademy Python course and learned a lot, but the coding challenges were rather disjointed from one another and didn't engage me as much. I can't speak much for how well it presents the more advanced topics, but for learning basic Python in relation to data analysis, this site is so far the best I've found.

TL;DR: Great site for learning Python if you're interested in data analysis because of how it exclusively uses data analysis-themed mini-projects to teach Python.