I think the best introduction to Python for our purpose (Handing data, and analysing data) is by compared it with Excel.
- Handling large datasets in Excel is slower than Python.
- Excel template is more difficult to reproduce than Python.
- Excel is not free and has no access to huge opensource library that Python has.
- Data analysis in Excel is more like mannual drag and drop rather than automated like Python.
Highly encourage all of you to learn Python, especially Pandas, a data analysis package. You would learn enough to read codes in my repository within weeks (Yes. My codes are not rocket science. I did not use any genius magic LOL).
- Download Anaconda distribution of python 3.7, OR
- search anaconda in Window's start menu
- type "cd direction/you/saved/the/program", e.g. cd "C:\Users\UserName\OneDrive - Mott MacDonald\Documents\summarizeOutstanding_3RS"
- type python fileName
- Python for Data Analysis. You can download it here This is the main book I read when I started learning Python.
- Automate the Boring Stuff with Python A good website to probably save you some time
Submit a pull request