This has been a great course...so far. It's making me take longer than necessary because I keep stopping to try things on my own data. Which is a good thing. Also I can see where I did some of this back in 2018, including stuff with SQLite. This helps me solve my one issue with this course...no SQL. So I stopped again because a customer database I created doesn't have an amount field which I want, so I can try out some pandas math methods. I have added a amount field to my random customer records but did not convert that to SQLite yet. I think having a lot of customers with an amount field will be fun to play with. It will allow me to select a various subsets of data, for example I can do amount calculations just on the people of Florida or Texans born in 1960 or Female Californians that are over 30 or a list of people who donated less than $1 or everyone just to see how python/pandas handles a lot of records...stuff like that there.
I defined the amount field as FLOAT in SQLite, which seems correct, I also saw REAL suggested. Viewing the amount looks like 28.35, 16.61, 7.18, 50.2 and so on. Summing a range of data produces the same answer in python/pandas as the LibreOffice Calc spreadsheet program.