Data_Analytics

This repository contains the data, notebooks and output for the analyses done in following stories:

• VLOOKUP implementation in Python in three simple steps
• Merit Order and Marginal Abatement Cost Curve in Python
• Wind energy physics and resource assessment with Python
• Learning curve effect on the global variable renewable energy deployment
• A complete word processing with Python.
• Running Python via Excel VBA - a case of time series resampling.
• Handling time zones with Python
• Creating a project updates tracker in Excel using VBA in three simple steps

Contributors

Himalaya Bir Shrestha

Package requirements

Besides the general packages such as pandas, matplotlib, numpy and scipy, pandas_datareader and plotly packages were installed for certain analytical works and data visualisation.Following packages were installed and used for "A complete word processing with Python" post: PyPDF2, PyMuPDF, python-docx, docx2pdf.