Short to medium long code snippets in a variety of programming and non-programming languages to do specific things
| Environment | File | Description |
|---|---|---|
| Python | fill_array_with_column_means.ipynb | a colleague was using procedural programming style to fill an array containing some nulls with column means. I mocked up a quick demo on how the power and elegance of vectorised operations in numpy and pandas can make life much simpler! (Complete) |
| Python | generate random survey dataset.ipynb | random data generator but the data adheres to specific distribution (Work in Progress) |
| Python | testing_interactive_dashboards_using_jupyter.ipynb | testing out the use of ipywidgets, plotly and other tools to create interactive dashboards in jupyter |
| Python | emulating_countif_functionality_in_python.ipynb | emulating Excel's countif functionality in python |
| Python | emulating_bining_functionality_in_python.ipynb | binning dataframe in python |
| Python | load_database_values_and_passwords_as_environment_variables.ipynb | while doing a project, load confidential login details as environment variables and dynamically access files by finding the root project directory. this is achieved by creating a project local environment file |
| Python | Test_logging_in_python.py | implementation of logging in python using dynamic dot-env |
| Python | execute_sqlscript_sqlite3.py | Runs SQL scripts against the sqlite database of your choice but reads no values back. You can use it for create, insert, update and delete statements |