DataCamp project Link to the project https://projects.datacamp.com/projects/1168
Image: St. Peter Stiftskeller, founded 803. Credit: Pakeha.
An important part of business is planning for the future and ensuring that the company survives changing market conditions. Some businesses do this really well and last for hundreds of years.
BusinessFinancing.co.uk researched the oldest company that is still in business in (almost) every country and compiled the results into a dataset. In this project, you'll explore that dataset to see what they found.
The database contains three tables.
| column | type | meaning |
|---|---|---|
category_code |
varchar | Code for the category of the business. |
category |
varchar | Description of the business category. |
| column | type | meaning |
|---|---|---|
country_code |
varchar | ISO 3166-1 3-letter country code. |
country |
varchar | Name of the country. |
continent |
varchar | Name of the continent that the country exists in. |
| column | type | meaning |
|---|---|---|
business |
varchar | Name of the business. |
year_founded |
int | Year the business was founded. |
category_code |
varchar | Code for the category of the business. |
country_code |
char | ISO 3166-1 3-letter country code. |
Let's begin by looking at the range of the founding years throughout the world.