CSV file question

Post Reply New Topic

I have a question about merging data from one CSV file to another:

In the first file, the fields are as follows: PetId, EnrollDate, CancelDate, Species, Breed, AgeAtEnroll

In the second file the fields are as follows: ClaimId, PetId, ClaimDate, ClaimAmount

I am trying to create a situation where in the second file, every instance of a certain value in PetId includes the corresponding data from the same PetId value from the first file. For example, when PetId = 100 in the first file, the EnrollDate, CancelDate, et al, for that PetId will be the same for every PetId = 100 in the second file.

In the first file, PetId has a unique value for each record, but that value can appear in multiple records in the second file.

This would be easy using a relational database.

The problem is that I need to use the files to analyze data in python. It makes no sense that the pet data and claims data are in different files.

This is the assignment:

Part 1 – Modeling
As an insurance company, we collect premium on a monthly basis from our customers. We then cover the customer’s veterinary bills should their pets receive medical treatment. Given the attached claim and pet data, predict how much we’ll pay in claims per pet in the following month.
- To clarify, I’m expecting a predicted sum for every PetId for the month of July 2019, along with the code you used to generate the solution - We typically use jupyter notebook, but feel free to use whatever language/tool you’re most comfortable with

Part 2 – Short Answer
Suppose our team is tasked with going into another insurance company and building an end-to-end solution to automate their claims process. Provide a summary of the work that needs to be done to accomplish this task.

Data analysis and data science are way over my head.