[# WebApplicationABShttps://www.loom.com/share/7027a568dceb48518e35aa4ae0000914] A web API in C# with two endpoints for GET requests. Data is stored in a MS SQL Server database. Data is about age and gender of population in different regions of Australia and is from ABS. The response is in JSON. Data is organised according to different regions each having a unique regionId. These regions are within the states in Australia. A python project is also included that loads and normalizes the data from a CSV file into a MS SQL Server DB. The data in CSV file is normalised to 3 DIM table and 1 FACT table. Python dataframe and Data series is used to filter and transform the data.
-
Notifications
You must be signed in to change notification settings - Fork 0
nadiyaali/Project-WebAPI
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Loads and normalize data from a CSV file using python to a MS SQL Server database. .NET WebAPI handles get requests for that data
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published