Fermé

Programming for problem solving

Introduction

Requirements

You have been tasked with creating a software application that can be used to process and manage data related to the COVID-19 observations. The requirements for the system are as follows:

a) The system will present the user with a text-based user interface through which a user will select options to load the data, process the data, persist the data and visualise the data.

b) The system will load the data from a CSV file into memory.

c) The system will allow the user to process the loaded data as follows: - Retrieve the total number of records that have been loaded. - Retrieve a record with the serial number as specified by the user. - Retrieve the records for the observation dates as specified by the user. - Retrieve all the records grouped by the country/region. - Retrieve a summary of all the records. This should include the following information for each country/region: - the total number of confirmed cases - the total number of deaths - the total number of recoveries

d) The system will allow the user to persist the data to a database. The data should be stored using an appropriate database model. You are required to design the database model.

e) The system will allow the user to utilise the data stored in the database to perform the following queries: - Retrieve the names of all (unique) countries in alphabetical order - Retrieve the number of confirmed cases, deaths, and recoveries for a specified observation / serial number. - Retrieve information for the top 5 countries for confirmed cases - Retrieve information for the top 5 countries for death for specific observation dates

f) The system will allow the user to visualise the data stored in the database as follows: - Display the top 5 countries for confirmed cases using a pie chart - Display the top 5 countries for death for specific dates using a bar chart - Display a suitable (animated) visualisation to show how the number of confirmed cases, deaths, and recovery change over time. This could focus on a specific country or countries.

Environment

You are required to use the following tools: - PyCharm as your integrated development environment - Python 3.8+ (preferably 3.9) as the standard python library - Additionally, the following libraries/modules may be imported and utilised:

csv – to process csv files

datatime – format strings as date and/or times

enum – to add enumerations

json – to process JSON files

matplotlib - to produce visualisations

os – to retrieve or check file paths

random – to generate random numbers

sqlite3 – to create and utilise a database

typing – to add type hints

unittest – to construct and run tests –

Git Tools and GitHub for version control –

No other python libraries or modules should be used

Compétences : Python, Programmation de bases de données, GitLab, Rédaction de Rapport

En voir plus : analysis problem solving terms programming aspnet, logo software problem solving testimonials, software problem solving approch skill net, problem solving skills software developer, software development good problem solving skills, programming logic problem solving repost, problem solving and programming, an introduction to problem solving and programming, computer programming problem solving process, introduction to programming with java a problem solving approach pdf, java an introduction to problem solving and programming, java an introduction to problem solving and programming 6th edition, java an introduction to problem solving and programming pdf, java an introduction to problem solving and programming solutions, matlab a practical introduction to programming and problem solving, matlab a practical introduction to programming and problem solving pdf, programming problem solving, programming problem solving techniques, programming problem solving skills, programming problem solving questions

Concernant l'employeur :
( 0 commentaires ) United Kingdom

Nº du projet : #32257971

30 freelances font une offre moyenne de 579 £ pour ce travail

topacademics

I will provide you quality report writing. I am a PhD writer with 10 years of experience. I have worked on several similar projects of report writing, and can deliver professional report writing to tight deadlines. You Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(877 Commentaires)
8.5
(267 Commentaires)
7.7
AwaisChaudhry

Hi there, I have read the brief details on the job listing. You can check my experience, customer feed backs and my portfolio here: https://www.freelancer.com/u/AwaisChaudhry?w=f I believe its a doable job I have grea Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 24 jours
(9 Commentaires)
6.5
liveexperts123

Hi there,I'm biddin on your project "Programming for problem solving" I have read your project description and i'm an expert in Python and machine learning therefore i can do this project for you perfectly.I still have Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(41 Commentaires)
6.6
shabih2468

Greetings I saw your project and as an expert in Python/ML/AI/DL I am sure I can do your task. I have previously worked on various state of the art deep learning projects which includes making models for text, music Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(51 Commentaires)
5.2
datascientist90

Hi - This job looks like a good fit with my skill set and experience. I hold Bachelor of Computer Science and Master of Data Science Please see my profile and reviews for references.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(11 Commentaires)
5.3
mirzaahamza

Heyy I am expert and I can help you with your project message me to discuss so that we can start working on it

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(37 Commentaires)
4.9
suyashdhoot

Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(43 Commentaires)
6.0
freelancerIrvan

Hi there, I am a talented python dev, and I suppose I can handle this task successfully. Please let me know more details, and Please give me your chance. I look forward to hearing from you. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(6 Commentaires)
4.5
(5 Commentaires)
4.7
Hiba023

Programming Hello there! After reading your instruction very carefully, I discovered that I am the worthier choice for your requirements. I will write high-quality articles for you. I have five years of experience as Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 20 jours
(15 Commentaires)
4.3
sapnathakur14

Hello, Warm Greetings! Upon checking your project, I am pretty sure I can produce high-quality and perfect results for your project. By using Python, I used to make AI engines, BOT, Web Scraping Tools, and so on. PHP, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(1 Évaluation)
4.2
Syedhammadhafeez

Hi, Hope you are doing well. kindly connect for further discussion, I am online and available. Regards, Syed Hammad A.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(2 Commentaires)
3.9
SergeyKuznetsovv

Hi there. I'm a senior Python developer with rich experience and familiar with Django, react.js. Here are my Python/node.js projects. ##### Web Scraping & Automation ##### [login to view URL] https:/ Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(3 Commentaires)
3.6
masifzahooreu

Hi Hope you are doing well We are full-time professional graphic designer. I have the outstanding experience to create creative modern mobile app logos or app icon designs for your business. So if you are in search Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(3 Commentaires)
2.9
oleksandryakoven

Hi, hope you are doing well. Are you looking for programming expert to process and manage the covid-19 data? I am a python developer with 7 years of experience. Hope to see you soon. Regards, Oleksandr

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(4 Commentaires)
2.9
itcdamico

Hello, I'm a professional Python developer. I'm confident with all the libraries you mentioned, so I can provide you an elegant, documented and efficient solution in very short time. Please, contact me to start working Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(7 Commentaires)
3.2
ahmedbilal2506

Hi sir I am interested to work with you. I can provide you with professional web design services. I can design for you according to your requirements. I will give you unlimited revision until you will not satisfy for y Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(3 Commentaires)
2.3
aravinda333

Hi, I have great experience in Python programming, implementing amazing applications from scratch, without the support of other libraries. I totally understand your requirements, and I'm extremely grateful to you f Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(4 Commentaires)
2.4
NEHABHAT92

Hey, Yes, understanding each aspect of the job description, I am available to take up this project and I assure you to complete it within a short period. The main advantage of this job is that i have been professio Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(2 Commentaires)
2.1