Analyzing Wijk Performance in Oss Using Social Domain Dataset

Aug 6, 2024, 1:29 PM

Gebruik_voorzieningen_sociaal_domein__aantal_voorzieningen__wijken__2021_06082024_135238.xlsx

Missing file

I would like to use this dataset to get insights in how each "wijk" performs compared to the total city of "Oss".

The dataset has been successfully loaded. Here is a preview of the first few rows:
WijkenAantal voorzieningen in 2021aantal Clienten Totaalaantal Clienten alleen Jeugdaantal clienten alleen P-wetaantal Clienten alleen WMOaantal Clienten Jeugd en P-wetaantal Clienten Jeugd en WMOaantal Clienten P-wet en WMOaantal clienten Jeugd, P-wet en WmoTotaal aantal Huishoudensaantal Huishoudens Alleen jeugdaantal Huishoudens alleen P-wetaantal Huishoudens alleen WMOaantal Huishoudens Jeugd en P-wetaantal Huishoudens Jeugd en WMOaantal Huishoudens P-wet en WMOaantal Huishoudens Jeugd, P-wet en WMO
OssTotaal120652160229566953030303022574080NaN55503015
Would you like to proceed with any specific analysis or visualization?

Can you visualize the distribution of clients across different categories for each wijk?

The bar chart above visualizes the distribution of clients across different categories for each wijk. Each color represents a different client category, and the height of the bars indicates the number of clients in that category for each wijk.
Would you like to perform any further analysis or explore other aspects of the data?

Thanks. Forgot to mention that "Totaal" is already a total column for al categories, so leave that one out. Can you give me a overview with 4 visuals that i could use on a dashboard for this dataset?

Here are four visuals that you can use on a dashboard for this dataset:
  1. Bar Chart: Distribution of Clients Across Different Categories for Each Wijk (Excluding Total)
  2. Pie Chart: Total Clients per Category
  3. Box Plot: Box Plot of Client Counts per Category
  4. Heatmap: Heatmap of Client Counts per Wijk and Category
These visuals provide a comprehensive overview of the distribution and summary statistics of clients across different categories and wijken.
Would you like to perform any further analysis or explore other aspects of the data?

Please give me the complete phyton code and include adding the data as a dataframe so i do not have to make a link to the dataset

Here is the complete Python code that includes loading the data as a dataframe and generating the four visuals:
Feel free to use this code to generate the visuals on your own system.
Would you like to perform any further analysis or explore other aspects of the data?
Get started with Vizly