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. What is Flash Fill in Excel?
Here are some samples.
You can learn Flash Fill in Excel here:
https://www.excel-easy.com/examples/flash-fill.html
II. Python does what Flash Fill does
Sample 1
Python code
Sample 2
Python code
Sample 3
Let me ask ChatGPT:
You can use Flash Fill on Excel online:
https://1drv.ms/x/s!AmlzIpnp3h4-jzb6hwV4gCg5t8V_?e=BLcYHB
You can see the Python code here:
https://colab.research.google.com/drive/1m1sqBROLqFDOxA3MCll0AXh970IfoEch?usp=sharing