Christine Zhang underthecurve

## kickstarter_sql_style_guide.md

      
              1 file
            
          
              89 forks
            
          
              14 comments
            
          
              409 stars
            
          
                fredbenenson
                / kickstarter_sql_style_guide.md
            
            
              Last active
              April 2, 2024 15:19
            
              
                Kickstarter SQL Style Guide
              
          
  layout
  title
  description
  tags
  
  
  default
  SQL Style Guide
  A guide to writing clean, clear, and consistent SQL.
  
  
  data
  process
  
  
Purpose


## useful_pandas_snippets.md

      
              1 file
            
          
              637 forks
            
          
              63 comments
            
          
              1441 stars
            
          
                bsweger
                / useful_pandas_snippets.md
            
            
              Last active
              April 19, 2024 18:04
            
              
                Useful Pandas Snippets
              
          
    Useful Pandas Snippets

A personal diary of DataFrame munging over the years.
Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)

(h/t @makmanalp)

  
## gist:5802497
#
# for details see
# http://bayesball.blogspot.ca/2013/06/annotating-select-points-on-x-y-plot.html
#
# load the ggplot2 and grid packages
library(ggplot2)
library(grid)
# read data (note csv files are renamed)
tbl1 = read.csv("FanGraphs_Leaderboard_h.csv")
tbl2 = read.csv("FanGraphs_Leaderboard_d.csv")
	#
	# for details see
	# http://bayesball.blogspot.ca/2013/06/annotating-select-points-on-x-y-plot.html
	#
	# load the ggplot2 and grid packages
	library(ggplot2)
	library(grid)
	# read data (note csv files are renamed)
	tbl1 = read.csv("FanGraphs_Leaderboard_h.csv")
	tbl2 = read.csv("FanGraphs_Leaderboard_d.csv")