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 tables in Google Sheets
You can see a table here:
https://docs.google.com/spreadsheets/d/1Y7MTLzxQXx7lRPmOar_73xs6aAiLKL3IeVRvtjeJ7Z0/edit?usp=sharing
II. Creating a data frame from dictionaries with Python
1. Creating a data frame
See Pandas 1 Creating DataFrames.
Data frames are two-dimensional labeled data structures having different types of columns like Excel sheets.
We will learn how to create a data frame from a dictionary here. You can also see the syntax to create one from lists. See Pandas 1 Syntax-Creating DataFrame.
You can see the scripts here:
https://colab.research.google.com/drive/1wyyZBlLprea5FlpecKqX6cK3EjgQydBL?usp=sharing
2. Creating dictionaries
See Cheat Sheets Basics IV 3 DICTIONARY.
Dictionaries are an unordered collection of items. Each item of a dictionary has a key-value pair. Use keys to access the values.
You can see the scripts here:
https://colab.research.google.com/drive/1wyyZBlLprea5FlpecKqX6cK3EjgQydBL?usp=sharing