Cocoon Cleaning Summary 🤗

---

📃 1. Table Summary

The table contains 2020 property sales data. It lists details for each property sale, including the address, property type, year built, square footage, number of rooms and bathrooms, lot size, sale date and price.

📊 2. Column Rename

😎 15 columns have been renamed

	Column	Summary	New Column Name	Renamed?
0	PropertyID	Unique identifier for the property	PropertyID	❌ No
1	PropType	Type of property (Residential, Commercial, etc.)	PropertyType	✔️ Yes
2	taxkey	Property tax key identifier	TaxKey	✔️ Yes
3	Address	Street address of the property	Address	❌ No
4	CondoProject	Name of the condo project if applicable	CondoProject	❌ No
5	District	District number where the property is located	District	❌ No
6	nbhd	Neighborhood code where the property is located	NeighborhoodCode	✔️ Yes
7	Style	Architectural style of the property	Style	❌ No
8	Extwall	Exterior wall material of the property	ExteriorWall	✔️ Yes
9	Stories	Number of stories the property has	NumStories	✔️ Yes
10	Year_Built	Year the property was originally built	YearBuilt	✔️ Yes
11	Rooms	Total number of rooms in the property	TotalRooms	✔️ Yes
12	FinishedSqft	Finished square footage of the property	FinishedSqFt	✔️ Yes
13	Units	Number of units the property has	NumUnits	✔️ Yes
14	Bdrms	Number of bedrooms in the property	Bedrooms	✔️ Yes
15	Fbath	Number of full bathrooms in the property	FullBathrooms	✔️ Yes
16	Hbath	Number of half bathrooms in the property	HalfBathrooms	✔️ Yes
17	Lotsize	Size of the property lot in square feet	LotSizeSqFt	✔️ Yes
18	Sale_date	Date the property was sold	SaleDate	✔️ Yes
19	Sale_price	Price the property was sold for	SalePrice	✔️ Yes

✂️ 3. Leading and Trailing Whitespace

🔍 2 columns have leading and trailing whitespace
✔️ 2 columns have been trimmed

🚧 4. Erroneous Values

🔍 1 columns have erroneous values

1. LotSizeSqFt: '0' and '1' are unusual because they are unrealistically small lot sizes.
   ❌ The column has not been cleaned
   
   

🕵️‍♂️ 5. Disguised Missing Values

🔍 1 columns have disguised missing values
✔️ 1 columns have been cleaned

	Column	Disguised Missing Values	Impute to NULL?	Values to NULL (Sep By ,)
0	LotSizeSqFt	[0, 1]	True	0,1

❓ 6. Missing Values

🔍 20 columns have missing values
✔️ 1 of them are acceptable

	Column	NULL (%)	Is NULL Acceptable?	Explanation
0	Address	0.02	False
1	Bedrooms	4.74	False
2	CondoProject	87.82	True	Not applicable for non-condo properties
3	District	0.03	False
4	ExteriorWall	12.67	False
5	FinishedSqFt	0.33	False
6	FullBathrooms	0.02	False
7	HalfBathrooms	0.02	False
8	LotSizeSqFt	12.81	False
9	NeighborhoodCode	0.41	False
10	NumStories	0.38	False
11	NumUnits	0.02	False
12	PropertyID	0.02	False
13	PropertyType	0.02	False
14	SaleDate	0.02	False
15	SalePrice	0.02	False
16	Style	0.30	False
17	TaxKey	0.02	False
18	TotalRooms	4.74	False
19	YearBuilt	0.14	False

🧩 These missing values are handled as follows:

	Column	NULL (%)	Strategy
0	Address	0.02	🔄 Unchanged
1	Bedrooms	4.74	🔄 Unchanged
2	District	0.03	🔄 Unchanged
3	ExteriorWall	12.67	🔄 Unchanged
4	FinishedSqFt	0.33	🔄 Unchanged
5	FullBathrooms	0.02	🔄 Unchanged
6	HalfBathrooms	0.02	🔄 Unchanged
7	LotSizeSqFt	12.81	🔄 Unchanged
8	NeighborhoodCode	0.41	🔄 Unchanged
9	NumStories	0.38	🔄 Unchanged
10	NumUnits	0.02	🔄 Unchanged
11	PropertyID	0.02	🔄 Unchanged
12	PropertyType	0.02	🔄 Unchanged
13	SaleDate	0.02	🔄 Unchanged
14	SalePrice	0.02	🔄 Unchanged
15	Style	0.30	🔄 Unchanged
16	TaxKey	0.02	🔄 Unchanged
17	TotalRooms	4.74	🔄 Unchanged
18	YearBuilt	0.14	🔄 Unchanged