Learning Python & Data Analysis
Introduction
Recently I have been teaching a friend how to programme in the language called Python and I thought I would make the resources we have been using available to all. Most of the material is based on the book called Automate the Boring Stuff. I have adapted those open source materials as needed for our programme.
Additional Resource Links
- Automate the Boring Stuff with Python
- Python Tasks
- Preface · A Byte of Python
- PY4E - Python for Everybody
- Welcome to Data Analysis in Python! — Data Analysis in Python 0.1 documentation
- School of Data - Evidence is Power
- Trinket Tool
Data Analysis Tools from 2022
- Pivot Tables in Google Sheets Tutorial
- Kaggle - Machine Learning Data Analysis
- How to Create a Dashboard in Google Sheets (10 steps) - Query Formula - YouTube
- How to Create Dropdown Filters on Google Sheets Dashboard Using QUERY Formula (ADVANCED TRICK) - YouTube
- How to Build a Professional Dashboard in Google Sheets (Query Formula Advanced Course) Step-by-Step - YouTube
- How to Create a Chart in Google Sheets to Analyze Google Forms Data | Tech Coach Weekly Ep10 - YouTube
- Turn Google Sheet data into a no-code web app with AppSheet | Google Cloud Blog
- Google Sheets Query: How to Create a Pivot Table
- Filtering With Dates In The QUERY Function -
- Google Sheets COUNTIF Function
- Query Language Reference (Version 0.7) | Charts | Google Developers
- The Ultimate Guide to Merging Spreadsheets | by Love Spreadsheets | Medium
- Merge 2 Google sheets and update data based on common records - Ablebits.com
- Google Sheets Query: Honest Guide with Formulas and Examples | Coupler.io Blog
- Google Sheets Query Function Explained - YouTube
- And, Or, and Not in Google Sheets Query [How to]
- Google Sheets Query: How to Use Multiple Criteria in Query - Statology
- Use Query Function as an Alternative to Filter Function
- QUERY Complete guide: Google Sheets' most complex function - YouTube
- Google Sheets - Comparing QUERY to "Regular" Functions like FILTER, SORT, UNIQUE and SORTN - YouTube
- The love-hate relationship between SELECT and GROUP BY in SQL | by Riccardo Odone | Medium
- Excel tutorial: Understanding data series
- How to Use a COUNTIF Function in Google Spreadsheets | Excelchat
- How to Filter Multiple Columns in Google Sheets (With Examples) - Statology
- Using Cell Reference in Filter Menu Filter by Condition in Google Sheets
Comments
Post a Comment