Geographical representation of (italian) data
I've started a (unpaid mandatory) intership and they basically gave me a massive csv sheet with uncleaned data to make sense of. I managed to clean it up and I now have created a SQL database with all the info, and I would love to get a geographical representation of the data, which looks like this:
| Progr | Periodo comp | Class.azienda | Comune | Provincia | Regione | ateco |
|---|---|---|---|---|---|---|
| 189923 | 2023-03-01 | DITTA | Canicattì | Agrigento | Sicilia | 47.52.2 |
I would like to represent the data geographically (by province, or region, or even better with a choropleth map) but excel or google sheet don't seem to be working with my input: google sheets says the data is incompatible, excel says "chek your data and try again". Would anyone be able to point me to ANYTHING at all that would work with this? I can use python, sql and I'm a pretty quick learner (albeit still kind of a newb to all of this). Thanks!
There are sites like datawrapper.de dedicated to importing data and making choropleth maps. You can upload your data as CSV, Excel, Link to external data, or connect to a google sheet. I was able to generate a low rez image without even signing-up. I guess if you sign-up they try to up-sell you on the hi-rez interactive versions of the maps.
- Query to find position in a string before keyword and extract data before that position
- SQL: get next relative day of week. (Next Monday, Tuesday, Wed.....)
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- java.sql.SQLException: Column Index out of range, 2 > 1
- Should LIKE 'searchstr%' use an index?
- Multiple STRING_AGG in one query
- Postgres: Add constraint if it doesn't already exist
- UPDATE Statement ignores INNER JOIN
- Execute Stored Procedure Minimal API .Net
- Change default schema for user
- Oracle SQL - Select oldest of 3 dates, but ignore NULLs
- Housing Society management system database structure
- Keep getting error: PLS-00103: Encountered the symbol "CREATE"
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Extract 4 million rows from database in chunks of 1 million rows each
- Aggregate into custom groups
- SQL query for chat application
- SQL basic problem when trying to SELECT 4 atributes and use GROUP BY with only 2
- How to modify query converting DATEDIFF to Oracle accepted syntax?
- Sales data analysis: calculate percentage of each product as per total sales
- Calculate the sum of values for the columns that meet the criteria
- Insert missing rows in time series consumption history
- Oracle database dependencies in PL/SQL
- How to autofill a field with data from another field in the same table?
- In Oracle: How to sort by group/cluster by a column value
- oracle SQL query - add date rows using different date
- How to fix products without cover image in PrestaShop
- IF ROW_COUNT() return error
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?