Try before you error

Try before you error

Problem to solve: importing many files into Power BI where some are not complete and trigger an ODBC error.

While importing thousands of JSON files I bumped into the situation where some of the files weren’t following the structure and thus caused an error and the import process to stop. The files were supposed to have some general and customer information about an order and order lines structured under “lines”.

Lees verder

Getting to know my computer

Problem to solve: fast find occurences of a string in thousands of files on a Windows computer

The first computer I ever worked with was the Mac SE, small, heavy, loud, with a nice graphical user interface. When I decided to follow a computer class, the first screen I saw was black with a nice c:\>. I thought the computer was broken. Windows 3.1 was yet to come. I never paid much attention to all the possibilities Windows offers nowadays until a few days ago.

Lees verder

exercise2-dash-plotly-python-pandas

Recreate dashboard with plotly and dash

To get more experience with python I decided to recreate a dashboard I saw online, don’t bother about the subject: https://www.who.int/data/gho/data/themes/mental-health/suicide-rates. You can filter and select the data to download, I used the most recent data (2019). On the Visualisations tab (using the WHO link above) you can find the dashboard I tried to make (the second visualisation).

Lees verder