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.

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:

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:

By mishou

Leave a Reply

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