data-recipes

Catch-all bucket of Python/R/Google Sheets snippets I dip into for data analysis; maybe you’ll find something useful too.

Python

• Clustering
  • Applying k-means clustering to sample banknote data
  • Applying k-means clustering to SEO using sample data from Google Search Console
• Marketing APIs
  • Google Analytics
  • Salesforce using SOQL
• Scraping
  • Using Scrapy to gather product review data
  • Analysing product review data using descriptive statistics and natural language processing
• Social
  • Download tweets using the Twitter API; sentiment analysis
  • Download page comments using the Facebook Graph API; sentiment analysis
• Stats
  • Learning about the beta distribution
  • General playground for exploring Pandas, Matplotlib, basic statistics etc.
• Time Convert by City: Convert from UTC to local time based on city name

R
=

• Marketing APIs
  • Google Analytics
  • Google Search Console
  • Salesforce using SOQL
• Sankey
  • Plot Sankey diagrams e.g. for seeing common paths between pages during a browser session
  • Data preperation for plotting Sankey diagrams using GA data
• Scraping
  • Search Results
• Venn
  • Draw up to 7-way Venn diagrams - impress your friends!
• Simulation of sample size mismatch effects on power in A/B tests
• Simulation for demonstrating the Monty Hall problem

Google Sheets

1. Date Dropdown: https://docs.google.com/spreadsheets/d/1uGNn-LMKrEoeDnLcqEHGv-t5H0EmgghraB1nmfilX3I/edit?usp=sharing
2. SEO Cluster Analysis: https://docs.google.com/spreadsheets/d/1PEvao-44P4Bdrl4ZjdbqMDjlW0EkQlOPN_qSVF4Kzis/edit?usp=sharing
3. Attribute Changes Matrix: https://docs.google.com/spreadsheets/d/1pbKp0PlXpRZ9FZbuu0L04UPYhIEPjz8SdHkeQXX9vHI/edit?usp=sharing
4. Hide/Unhide Rows using Apps Script: https://docs.google.com/spreadsheets/d/1KQnXiOp6i7Fjj7F3qrMLRf2dS9cvRsOSjLnv3YzK06k/edit?usp=sharing
5. Rolling Average + Confidence Intervals: https://docs.google.com/spreadsheets/d/16S0QwMPvK0nV1CFX-egFhfuusDO9pbHDJ5TBfyBTYaA/edit?usp=sharing
6. Two-proportion Z Test/Sample Size Calculator: https://docs.google.com/spreadsheets/d/1Ltxkvsl9oVJbV7wUR-38IJ4LXgOiO5usjGUlbA1E9Bg/edit?usp=sharing
7. Beta Distribution Calculator: https://docs.google.com/spreadsheets/d/1f8HqUIgQVv_jF-tBDEtBL_7H42R_XM6uK8LUyRdp19E/edit?usp=sharing
8. Drag Formula Right and Read Column Down: https://docs.google.com/spreadsheets/d/1aJNvgM3ci6qIEL06xULQN6Ibda5LrK4PRe7HlcLccNI/edit?usp=sharing
9. Geo Chart: https://docs.google.com/spreadsheets/d/1nYViS9U5Cp_17sugEbB-v6FvKtd8b7XXT52euCK7EWY/edit?usp=sharing
10. Sample Ratio Mismatch Calculator: https://docs.google.com/spreadsheets/d/1Lnfqu-zANL2Kc2S7UUfcwbMbJV_h-IZ9yKLPKL6fwpI/edit?usp=sharing
11. A/B … N Calculator: https://docs.google.com/spreadsheets/d/1Wcspsnt154rtO7j2hF1fYO0Z-knvC-8Zf3AomvqKM28/edit?usp=sharing
12. Custom Filter Functions in Apps Script: https://docs.google.com/spreadsheets/d/1h0L37Gi4Z6FyR5at6OHv8IrWwaQYyXF_bS3wEhwi82k/edit?usp=sharing