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. Using Macros on Google Sheets

Let’s load the data from the following URL for the raw CSV data using Macro and create two histograms for the “english” and “japanese” columns.

You can see the sheets here :

II. Creating Histograms with Python

You can create the histograms with Python like this:

You can see the code here:

To be continued.

By mishou

Leave a Reply

Your email address will not be published. Required fields are marked *