Last Updated on May 4, 2023 by mishou
Work in progress.
1. Basics 1 Self-taught learning
2. Basics 2 Making your cheat sheets
3. Basics 3 Google Colaboratory
4. Basics 4 Mathematical operators
5. Basics 5 Autofill and List Comprehensions
6. Basics 6 Tables
7. Basics 7 Classes and Objects
8. Basics 8 Pivot Tables
9. Basics 9 Sample Data Sets
10. Basics 10 Flash Fill
11. Basics 11 Charts
12. Basics 12 Loops
13. Basics 13 Funcitons
14. Basics 14 Macros
I. Creating charts on Google Sheets
Here is the data:
https://pastebin.com/raw/cSZ8pYWh
1. Histogram
2. Bar chart grouped by nationality using Pivot Table
3. Scatter plot
This might be interesting but cumbersome.
You can see the sheets here:
https://docs.google.com/spreadsheets/d/1LCMletCCx0Kf6KIkXz9nc00BAQrquKo61Ydvu7uyKVI/edit?usp=sharing
II. Creating charts with Python
1. Histogram
2. Bar Chart grouped by nationality
3. Scatter Plot
III. Automatically Visualize the dataset with autoviz
You can see all the Python code here:
https://colab.research.google.com/drive/1JAVfrO44IdWW93_Jyc32scDtld7Oazf0?usp=sharing