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. Autofill on Google Sheets
Select cells and drag down the fill handle at the bottom-right edge.
https://youtube.com/watch?v=x6c6D9MQvto%3Ffeature%3Doembed
II. Lists in Python
Lists have the following characteristics:
- The lists are mutable.
- A list can store objects of any type.
- The lists are ordered.
- The element of the list can be accessed by index.
You can see sample lists here:
https://colab.research.google.com/drive/1X5K7x7wsuRruhPo2NmxWAM74-Exb03hw?usp=sharing
III. List Comprehensions in Python
List comprehensions offer a shorter syntax when you want to create a new list based on the values of an existing list. It is syntactic sugar that makes code easier to read and write.
You can create a similar data frame to the table created above in Google Sheets:
You can see sample scripts here:
https://colab.research.google.com/drive/1J6l72PcDfBXMg7alpm5U5-bxJXkl9a5X?usp=sharing