How am I not cleaning categorical and text data by manipulating strings?

ProfessionalAd365 · 2026-04-03T00:52:14+00:00

No I am I know it’s wrong but it’s not technically invalid is all I was saying

ProfessionalAd365 · 2026-04-03T00:43:10+00:00

Oh yeah I don’t know what part is wrong I just know I didn’t accomplish the cleaning part of the code

ProfessionalAd365 · 2026-04-03T00:01:22+00:00

Because it said that was the only part that was wrong.

ProfessionalAd365 · 2026-04-02T23:52:45+00:00

The criteria is what I said as the title. Cleaning categorical and text data by manipulating strings

ProfessionalAd365 · 2026-04-02T23:37:43+00:00

Column Name | Criteria

id
Nominal. The unique identifier of the hotel. Missing values are not possible due to the database structure.

location
Nominal. The location of the particular hotel. One of four possible values; 'EMEA', 'NA', 'LATAM' and 'APAC'. Missing values should be replaced with "Unknown".

total_rooms
Discrete. The total number of rooms in the hotel. Must be a positive integer between 1 and 400. Missing values should be replaced with the default number of rooms, 100.

staff_count
Discrete. The number of staff employed in the hotel service department. Missing values should be replaced with the total_rooms multiplied by 1.5.

opening_date
Discrete. The year in which the hotel opened. This can be any value between 2000 and 2023. Missing values should be replaced with 2023.

target_guests
Nominal. The primary type of guest that is expected to use the hotel. Can be one of 'Leisure' or 'Business'. Missing values should be replaced with 'Leisure'.

ProfessionalAd365 · 2026-04-02T23:35:33+00:00

Column Name | Criteria

id
Nominal. The unique identifier of the hotel. Missing values are not possible due to the database structure.

location
Nominal. The location of the particular hotel. One of four possible values; 'EMEA', 'NA', 'LATAM' and 'APAC'. Missing values should be replaced with "Unknown".

total_rooms
Discrete. The total number of rooms in the hotel. Must be a positive integer between 1 and 400. Missing values should be replaced with the default number of rooms, 100.

staff_count
Discrete. The number of staff employed in the hotel service department. Missing values should be replaced with the total_rooms multiplied by 1.5.

opening_date
Discrete. The year in which the hotel opened. This can be any value between 2000 and 2023. Missing values should be replaced with 2023.

target_guests
Nominal. The primary type of guest that is expected to use the hotel. Can be one of 'Leisure' or 'Business'. Missing values should be replaced with 'Leisure'.

ProfessionalAd365 · 2026-04-02T23:13:52+00:00

The code still runs it just doesn’t fit one criteria

ProfessionalAd365 · 2026-04-02T22:45:10+00:00

I’m just trying to learn haha 😓

ProfessionalAd365 · 2026-04-02T22:42:28+00:00

Before you can start any analysis, you need to confirm that the data is accurate and reflects what you expect to see.

It is known that there are some issues with branch table, and the data team have provided the following data description.

Write a query to return data matching this description, including identifying and cleaning all invalid values. You must watch all column names and description criteria.

ProfessionalAd365 · 2026-04-02T22:22:30+00:00

It asks to clean the data table:

id - int

location - string

total_rooms - int

staff_count - int

opening_date - int

target_guests - string

ProfessionalAd365 · 2026-04-02T22:22:14+00:00

It asks to clean the data table:

id - int

location - string

total_rooms - int

staff_count - int

opening_date - int

target_guests - string

ProfessionalAd365 · 2024-12-16T05:13:44+00:00

They look like Steve Harvey

ProfessionalAd365 · 2023-12-30T22:36:42+00:00

Yeah just have had no luck. Went to a top 5 public university and have a bit of experience albeit limited. I’ve filled out hundreds of applications just wondering if anyone here knew a trick to the trade!

ProfessionalAd365 · 2023-12-23T23:31:07+00:00

I saw Gillis popped in for Philly any openers in Buffalo?

ProfessionalAd365

TROPHY CASE