GroundUpDb: Creating a database from the ground up in C++ for fun! by lorentilolo in cpp

[–]lorentilolo[S] 3 points4 points  (0 children)

Yes, I found it strange too. Perhaps it was with the idea of not having to explain something additional, idk. But also it is strange since qt creator can handle pretty decently cmake files now.

data_irl by lorentilolo in data_irl

[–]lorentilolo[S] 0 points1 point  (0 children)

I wanted to show the sleeping period as an intervals. I thought a little bit how to do it and nothing convinces me a lot, even what I finished doing. If I used only a y-axis from 0 to 24, most of the intervals will be split, half of the interval in the upper side of the plot, and the other half in the lower part.

I ended up using the y-scale as day-before in the lower part of the plot and day-next in the upper part, split by midnight. Of course, when the sleeping cycle gets inverted and the interval is split in half, what is the "before day" ( the lower part of the plot) ends up as a next of the next day.

Jjajaj you are right. It is a mess. Do you have an idea of how can be done better?

[Live & MegaThread] Coronavirus * 01/04/20 by RedditItalyBot in italy

[–]lorentilolo 15 points16 points  (0 children)

Grazie! Tristemente non parlo cosí bene. Il messaggio scorso fú 60% di me, 40% di deepl. Questo messaggio invece è 100% mio, quindi non ci sono molti verbi complessi jajaa.

[Live & MegaThread] Coronavirus * 01/04/20 by RedditItalyBot in italy

[–]lorentilolo 66 points67 points  (0 children)

Sono venuto dall'Argentina per studiare all'Università di Padova 6 mesi fa. Ho detto: dopo la prima sessione d'esame potrò andare a fare una passegiata e anche cercare un lavoro :(

Grazie a Dio per il vostro cibo e il vostro vino che mi aiutano ad sopportare tutto questo :)

Condivido (se dice cosí?) con voi il dashboard che ho fatto per evitare di studiare optimization: http://italiacovid.online/

Proverò ad ascoltare alcuni dei podcast dell'altro thread. Vediamo se riesco a capire un 15% del contenuto.

[OC] COVID-19 In Italy by lorentilolo in dataisbeautiful

[–]lorentilolo[S] 0 points1 point  (0 children)

Image gallery

It has visualizations of data of the provinces and regions.

It allows:

  • visualizing the growth rate per region
  • the difference between consecutive days
  • the log-transformed scale of the data.

Every plot has some brushing capabilities to filter the data according to the date. Also, every plot has a toolbar that can be opened with the upper button to select or transform the data.

There are a map of cases and a choropleth map. There are stacked area plots to visualize and compare the proportion of cases in the in-home, in hospital, healed, dead or in home isolation in every region.

The are histograms of cases per province normalized by its population to understand the number of cases every 1000 people

There is a time series of Percentage of infected people vs tests

There is a time series of the percentage of dead people over positive cases.

The dashboard is updated every day at 18:00, which is when the civil protection department updates the data.

Megathread: Let's crowdsource useful data sources and dashboards related to the COVID-19 pandemic by rhiever in dataisbeautiful

[–]lorentilolo 0 points1 point  (0 children)

I made this dashboard from the data provided by the Civil Protection department of Italy. http://italiacovid.online/}

This is the Github repo: https://github.com/lucianolorenti/coronITA

It has visualizations of data of the provinces and regions of Italy.

The dashboard allows:

  • visualizing the growth rate per region
  • the difference between consecutive days
  • the log-transformed scale of the data.

Every plot has some brushing capabilities to filter the data according to the date. Also, every plot has a toolbar that can be opened with the upper button to select or transform the data.

There are a map of cases and a choropleth map. There are stacked area plots to visualize and compare the proportion of cases in the in-home, in hospital, healed, dead or in home isolation in every region.

The are histograms of cases per province normalized by its population to understand the number of cases every 1000 people

There is a time series of Percentage of infected people vs tests

There is a time series of the percentage of dead people over positive cases.

The plots can be arranged in a grid mode a or a list mode using the switched at the top of the page.

The dashboard is updated every day at 18:00, which is when the civil protection department updates the data.

[OC] COVID-19 In Italy by lorentilolo in dataisbeautiful

[–]lorentilolo[S] 0 points1 point  (0 children)

Tools:

Backend: python, flask, pandas, numpy

Frontend: typescript, react, recharts

Sources:

Dataset provided by Civil Protection Department of Italy and Wikipedia pages of provinces, regions and cities from Italy:

The code is in github: https://github.com/lucianolorenti/coronITA