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 pivot tables in Google Sheets
Sample 1: Attendance
Sample 2: Questionnaire
Sample 3: Exam resykts
You can see the pivot tables here:
https://docs.google.com/spreadsheets/d/1gZtgnRSkkx0ymXSgNE__WX7W4YIF3W0chUJvT2U63b4/edit?usp=sharing
II. Creating pivot tables with Python
Sample 1: Attendance
You should not usePivot Tables. Use sum(axis=0) instead.
Sample 2: Questionnaire
You can see the scripts here:
https://colab.research.google.com/drive/1R1SPo8V8ANmanRxe7TL0bxzY-y47iQLj?usp=sharing
You can’t use a column as both a “value” and an “index” at the same time. See:
pandas pivot table value as column or index