Python | R | SQL

General Programing Resources

• Problem Decomposition

Python

Most of the material here is presented as IPython notebooks. The main links will take you to a nicely formatted text version of the notebook displayed in the browser. You can also download the actual notebook to interact with it on your computer by changing the code and seeing what happens.

• Expressions (notebook)
• Types (notebook)
• Integer Division (notebook)
• Variables and Assignment (notebook)
• Using Functions (notebook)
• Writing Functions (notebook)
• Strings (notebook)
• Lists: loops, methods, and nested lists
• For loops (notebook)
• While loops (notebook)
• Importing delimited text files (notebook)
• Web data
• Exporting data from Python (notebook)
• Numpy (notebook)
• Graphing (notebook)
• Statistics (notebook)
• Interacting with Databases from Python (notebook)
• List comprehensions (notebook)
• Debugging
• Debugger
• Testing
• Style
• Program Design (notebook)
• Common points of confusion in Python (notebook)
• Python & R (notebook | raw notebook)

R

• Introduction
• Data Structures
• dplyr
• ggplot
• Functions
• for loops
• Conditionals
• Problem Decomposition (R-script)
• Genomics Example
• Version Control
• Integrating R and SQL
• Project Structure
• Debugging

SQL

• Introduction to Databases (presentation)
• Database Structure (presentation)
• Tidy Data
• Adding Data
• Creating Tables
• Updating Tables
• Joins
• Nested Queries