Source: /home/coolhand/html/datavis/data_trove/data/urban/nyc_housing/nyc_tenure_by_tract.csv
Saturn profiled 2,327 rows across 10 columns. The stats below are deterministic and machine-readable; the prose is a language-model interpretation of those stats (opt-in, added after the fact, never sees raw rows).
!pip install saturn-dissect
import subprocess
subprocess.run([
"saturn", "analyze", "/home/coolhand/html/datavis/data_trove/data/urban/nyc_housing/nyc_tenure_by_tract.csv",
"--findings", "nyc_housing-nyc_tenure_by_tract.json",
"--llm", "anthropic:claude-opus-4-7",
])This dataset contains 2,327 New York City census tracts with housing tenure breakdowns across 10 columns, covering owner- and renter-occupied household counts and percentages by county. Brooklyn (Kings) leads with 805 tracts (34.6% of rows), followed by Queens (725) and Bronx (361), while Staten Island has just 126. Renting dominates citywide: the mean share of renter-occupied households is 62.5% versus 37.5% owner-occupied, and renter counts are right-skewed with a long tail up to 8,209 per tract. Worth a closer look: the strong skew in raw household counts (owner_occupied skew 1.76, renter_occupied skew 1.59) and the ~4% null rate in the percentage columns. Note that 'state' is constant (all 36) and can be ignored.
citing: row_count · column_count · county_name.top_values · county_name.top_rate · pct_owner_occupied.mean · pct_renter_occupied.mean · owner_occupied.skew · renter_occupied.skew · renter_occupied.max · pct_owner_occupied.null_rate · state.n_unique
saturn.schema() · 10 columns
| column | kind | n | null% | unique | alerts |
|---|---|---|---|---|---|
| total_households | numeric | 2,327 | 0.0% | 1,495 | |
| owner_occupied | numeric | 2,327 | 0.0% | 1,001 | outliers |
| renter_occupied | numeric | 2,327 | 0.0% | 1,418 | |
| NAME | text | 2,327 | 0.0% | 2,327 | near_unique |
| state | numeric | 2,327 | 0.0% | 1 | constant |
| county | numeric | 2,327 | 0.0% | 5 | |
| tract | numeric | 2,327 | 0.0% | 1,530 | high_skew |
| county_name | categorical | 2,327 | 0.0% | 5 | |
| pct_owner_occupied | numeric | 2,327 | 4.1% | 823 | |
| pct_renter_occupied | numeric | 2,327 | 4.1% | 823 |
| value | count | share |
|---|---|---|
| Brooklyn (Kings) | 805 | 34.6% |
| Queens | 725 | 31.2% |
| Bronx | 361 | 15.5% |
| Manhattan (New York) | 310 | 13.3% |
| Staten Island (Richmond) | 126 | 5.4% |
| bin | count |
|---|---|
| 0 – 2.5 | 141 |
| 2.5 – 5 | 86 |
| 5 – 7.5 | 71 |
| 7.5 – 10 | 63 |
| 10 – 12.5 | 86 |
| 12.5 – 15 | 65 |
| 15 – 17.5 | 72 |
| 17.5 – 20 | 88 |
| 20 – 22.5 | 98 |
| 22.5 – 25 | 88 |
| 25 – 27.5 | 79 |
| 27.5 – 30 | 67 |
| 30 – 32.5 | 70 |
| 32.5 – 35 | 56 |
| 35 – 37.5 | 76 |
| 37.5 – 40 | 68 |
| 40 – 42.5 | 59 |
| 42.5 – 45 | 72 |
| 45 – 47.5 | 58 |
| 47.5 – 50 | 54 |
| 50 – 52.5 | 70 |
| 52.5 – 55 | 59 |
| 55 – 57.5 | 55 |
| 57.5 – 60 | 39 |
| 60 – 62.5 | 44 |
| 62.5 – 65 | 40 |
| 65 – 67.5 | 52 |
| 67.5 – 70 | 34 |
| 70 – 72.5 | 40 |
| 72.5 – 75 | 47 |
| 75 – 77.5 | 32 |
| 77.5 – 80 | 48 |
| 80 – 82.5 | 31 |
| 82.5 – 85 | 27 |
| 85 – 87.5 | 26 |
| 87.5 – 90 | 24 |
| 90 – 92.5 | 23 |
| 92.5 – 95 | 8 |
| 95 – 97.5 | 6 |
| 97.5 – 100 | 9 |
| bin | count |
|---|---|
| 0 – 2.5 | 9 |
| 2.5 – 5 | 6 |
| 5 – 7.5 | 7 |
| 7.5 – 10 | 23 |
| 10 – 12.5 | 24 |
| 12.5 – 15 | 26 |
| 15 – 17.5 | 27 |
| 17.5 – 20 | 32 |
| 20 – 22.5 | 47 |
| 22.5 – 25 | 31 |
| 25 – 27.5 | 48 |
| 27.5 – 30 | 40 |
| 30 – 32.5 | 34 |
| 32.5 – 35 | 50 |
| 35 – 37.5 | 39 |
| 37.5 – 40 | 46 |
| 40 – 42.5 | 41 |
| 42.5 – 45 | 53 |
| 45 – 47.5 | 57 |
| 47.5 – 50 | 72 |
| 50 – 52.5 | 54 |
| 52.5 – 55 | 54 |
| 55 – 57.5 | 73 |
| 57.5 – 60 | 62 |
| 60 – 62.5 | 69 |
| 62.5 – 65 | 72 |
| 65 – 67.5 | 60 |
| 67.5 – 70 | 65 |
| 70 – 72.5 | 72 |
| 72.5 – 75 | 75 |
| 75 – 77.5 | 91 |
| 77.5 – 80 | 94 |
| 80 – 82.5 | 92 |
| 82.5 – 85 | 73 |
| 85 – 87.5 | 64 |
| 87.5 – 90 | 83 |
| 90 – 92.5 | 65 |
| 92.5 – 95 | 71 |
| 95 – 97.5 | 83 |
| 97.5 – 100 | 147 |
| bin | count |
|---|---|
| 0 – 205.2 | 123 |
| 205.2 – 410.4 | 41 |
| 410.4 – 615.7 | 203 |
| 615.7 – 820.9 | 272 |
| 820.9 – 1026 | 269 |
| 1026 – 1231 | 237 |
| 1231 – 1437 | 215 |
| 1437 – 1642 | 221 |
| 1642 – 1847 | 162 |
| 1847 – 2052 | 134 |
| 2052 – 2257 | 94 |
| 2257 – 2463 | 101 |
| 2463 – 2668 | 66 |
| 2668 – 2873 | 39 |
| 2873 – 3078 | 35 |
| 3078 – 3284 | 24 |
| 3284 – 3489 | 22 |
| 3489 – 3694 | 8 |
| 3694 – 3899 | 7 |
| 3899 – 4104 | 9 |
| 4104 – 4310 | 13 |
| 4310 – 4515 | 9 |
| 4515 – 4720 | 5 |
| 4720 – 4925 | 5 |
| 4925 – 5131 | 3 |
| 5131 – 5336 | 2 |
| 5336 – 5541 | 2 |
| 5541 – 5746 | 0 |
| 5746 – 5952 | 1 |
| 5952 – 6157 | 1 |
| 6157 – 6362 | 0 |
| 6362 – 6567 | 0 |
| 6567 – 6772 | 1 |
| 6772 – 6978 | 2 |
| 6978 – 7183 | 0 |
| 7183 – 7388 | 0 |
| 7388 – 7593 | 0 |
| 7593 – 7799 | 0 |
| 7799 – 8004 | 0 |
| 8004 – 8209 | 1 |
| bin | count |
|---|---|
| 0 – 205.2 | 349 |
| 205.2 – 410.4 | 358 |
| 410.4 – 615.7 | 292 |
| 615.7 – 820.9 | 268 |
| 820.9 – 1026 | 207 |
| 1026 – 1231 | 175 |
| 1231 – 1437 | 168 |
| 1437 – 1642 | 110 |
| 1642 – 1847 | 100 |
| 1847 – 2052 | 68 |
| 2052 – 2257 | 63 |
| 2257 – 2463 | 42 |
| 2463 – 2668 | 36 |
| 2668 – 2873 | 22 |
| 2873 – 3078 | 19 |
| 3078 – 3284 | 17 |
| 3284 – 3489 | 6 |
| 3489 – 3694 | 5 |
| 3694 – 3899 | 4 |
| 3899 – 4104 | 6 |
| 4104 – 4310 | 5 |
| 4310 – 4515 | 3 |
| 4515 – 4720 | 1 |
| 4720 – 4925 | 0 |
| 4925 – 5131 | 1 |
| 5131 – 5336 | 1 |
| 5336 – 5541 | 0 |
| 5541 – 5746 | 0 |
| 5746 – 5952 | 0 |
| 5952 – 6157 | 0 |
| 6157 – 6362 | 0 |
| 6362 – 6567 | 0 |
| 6567 – 6772 | 0 |
| 6772 – 6978 | 0 |
| 6978 – 7183 | 0 |
| 7183 – 7388 | 0 |
| 7388 – 7593 | 0 |
| 7593 – 7799 | 0 |
| 7799 – 8004 | 0 |
| 8004 – 8209 | 1 |
| column | kind | null % |
|---|---|---|
| total_households | numeric | 0.0% |
| owner_occupied | numeric | 0.0% |
| renter_occupied | numeric | 0.0% |
| NAME | text | 0.0% |
| state | numeric | 0.0% |
| county | numeric | 0.0% |
| tract | numeric | 0.0% |
| county_name | categorical | 0.0% |
| pct_owner_occupied | numeric | 4.1% |
| pct_renter_occupied | numeric | 4.1% |
| total_households | owner_occupied | renter_occupied | state | county | tract | pct_owner_occupied | pct_renter_occupied | |
|---|---|---|---|---|---|---|---|---|
| total_households | +1.00 | +0.44 | +0.89 | +nan | -0.04 | -0.12 | -0.20 | +0.20 |
| owner_occupied | +0.44 | +1.00 | -0.02 | +nan | +0.27 | +0.21 | +0.15 | -0.15 |
| renter_occupied | +0.89 | -0.02 | +1.00 | +nan | -0.18 | -0.23 | -0.30 | +0.30 |
| state | +nan | +nan | +nan | +nan | +nan | +nan | +nan | +nan |
| county | -0.04 | +0.27 | -0.18 | +nan | +1.00 | +0.18 | +0.35 | -0.35 |
| tract | -0.12 | +0.21 | -0.23 | +nan | +0.18 | +1.00 | +0.29 | -0.29 |
| pct_owner_occupied | -0.20 | +0.15 | -0.30 | +nan | +0.35 | +0.29 | +1.00 | -1.00 |
| pct_renter_occupied | +0.20 | -0.15 | +0.30 | +nan | -0.35 | -0.29 | -1.00 | +1.00 |
Counts of households per geographic unit, ranging from 0 to 8209 with a median of 1252 and mean of 1410.7. The distribution is right-skewed (skew 1.48, kurtosis 4.38) with 70 outliers (3.0%) on the high end, and 4.1% of rows are zeros which may indicate uninhabited or unreported areas.
Treatment: Consider log1p-transform before regression to tame the right skew and zero inflation.
saturn.columns["total_households"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 1,495 |
| min | 0 |
| max | 8,209 |
| mean | 1411 |
| median | 1,252 |
| std | 923.3 |
| q1 | 773.5 |
| q3 | 1,850 |
| iqr | 1076 |
| skew | 1.479 |
| kurtosis | 4.377 |
| n_outliers | 70 |
| outlier_rate | 0.03008 |
| zero_rate | 0.04125 |
total_households. Vertical dash marks the median.
| bin | count |
|---|---|
| 0 – 205.2 | 123 |
| 205.2 – 410.4 | 41 |
| 410.4 – 615.7 | 203 |
| 615.7 – 820.9 | 272 |
| 820.9 – 1026 | 269 |
| 1026 – 1231 | 237 |
| 1231 – 1437 | 215 |
| 1437 – 1642 | 221 |
| 1642 – 1847 | 162 |
| 1847 – 2052 | 134 |
| 2052 – 2257 | 94 |
| 2257 – 2463 | 101 |
| 2463 – 2668 | 66 |
| 2668 – 2873 | 39 |
| 2873 – 3078 | 35 |
| 3078 – 3284 | 24 |
| 3284 – 3489 | 22 |
| 3489 – 3694 | 8 |
| 3694 – 3899 | 7 |
| 3899 – 4104 | 9 |
| 4104 – 4310 | 13 |
| 4310 – 4515 | 9 |
| 4515 – 4720 | 5 |
| 4720 – 4925 | 5 |
| 4925 – 5131 | 3 |
| 5131 – 5336 | 2 |
| 5336 – 5541 | 2 |
| 5541 – 5746 | 0 |
| 5746 – 5952 | 1 |
| 5952 – 6157 | 1 |
| 6157 – 6362 | 0 |
| 6362 – 6567 | 0 |
| 6567 – 6772 | 1 |
| 6772 – 6978 | 2 |
| 6978 – 7183 | 0 |
| 7183 – 7388 | 0 |
| 7388 – 7593 | 0 |
| 7593 – 7799 | 0 |
| 7799 – 8004 | 0 |
| 8004 – 8209 | 1 |
Despite the boolean-sounding name, owner_occupied is an integer count ranging 0–3052 with 1001 distinct values and a mean of 464.6 versus a median of 371, suggesting a per-area tally of owner-occupied units rather than a flag. The distribution is right-skewed (skew 1.76, kurtosis 4.25) with 143 outliers (6.1%) and 7.2% exact zeros. No nulls are present.
Treatment: Log-transform or winsorize before modelling to tame the right tail.
saturn.columns["owner_occupied"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 1,001 |
| min | 0 |
| max | 3,052 |
| mean | 464.6 |
| median | 371 |
| std | 422.6 |
| q1 | 177 |
| q3 | 608 |
| iqr | 431 |
| skew | 1.761 |
| kurtosis | 4.254 |
| n_outliers | 143 |
| outlier_rate | 0.06145 |
| zero_rate | 0.0722 |
| alert: outliers | 6.1% rows beyond 1.5 IQR |
owner_occupied. Vertical dash marks the median.
| bin | count |
|---|---|
| 0 – 76.3 | 343 |
| 76.3 – 152.6 | 175 |
| 152.6 – 228.9 | 191 |
| 228.9 – 305.2 | 236 |
| 305.2 – 381.5 | 258 |
| 381.5 – 457.8 | 245 |
| 457.8 – 534.1 | 167 |
| 534.1 – 610.4 | 134 |
| 610.4 – 686.7 | 98 |
| 686.7 – 763 | 69 |
| 763 – 839.3 | 61 |
| 839.3 – 915.6 | 49 |
| 915.6 – 991.9 | 53 |
| 991.9 – 1068 | 43 |
| 1068 – 1144 | 33 |
| 1144 – 1221 | 21 |
| 1221 – 1297 | 20 |
| 1297 – 1373 | 28 |
| 1373 – 1450 | 16 |
| 1450 – 1526 | 18 |
| 1526 – 1602 | 9 |
| 1602 – 1679 | 13 |
| 1679 – 1755 | 9 |
| 1755 – 1831 | 8 |
| 1831 – 1908 | 5 |
| 1908 – 1984 | 2 |
| 1984 – 2060 | 4 |
| 2060 – 2136 | 3 |
| 2136 – 2213 | 3 |
| 2213 – 2289 | 1 |
| 2289 – 2365 | 2 |
| 2365 – 2442 | 2 |
| 2442 – 2518 | 3 |
| 2518 – 2594 | 0 |
| 2594 – 2670 | 3 |
| 2670 – 2747 | 0 |
| 2747 – 2823 | 1 |
| 2823 – 2899 | 0 |
| 2899 – 2976 | 0 |
| 2976 – 3052 | 1 |
This column reports the count of renter-occupied units per record, ranging from 0 to 8209 with a mean of 946 and median of 726. The distribution is right-skewed (skew 1.59, kurtosis 4.63) with 4.4% zeros and 69 outliers (2.97%) in the upper tail. No nulls and 1418 unique values across 2327 rows suggest a per-area aggregate count rather than a per-unit flag.
Treatment: Log-transform (log1p to handle zeros) before regression to tame right skew.
saturn.columns["renter_occupied"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 1,418 |
| min | 0 |
| max | 8,209 |
| mean | 946.1 |
| median | 726 |
| std | 815.4 |
| q1 | 346 |
| q3 | 1,357 |
| iqr | 1,011 |
| skew | 1.595 |
| kurtosis | 4.627 |
| n_outliers | 69 |
| outlier_rate | 0.02965 |
| zero_rate | 0.04383 |
renter_occupied. Vertical dash marks the median.
| bin | count |
|---|---|
| 0 – 205.2 | 349 |
| 205.2 – 410.4 | 358 |
| 410.4 – 615.7 | 292 |
| 615.7 – 820.9 | 268 |
| 820.9 – 1026 | 207 |
| 1026 – 1231 | 175 |
| 1231 – 1437 | 168 |
| 1437 – 1642 | 110 |
| 1642 – 1847 | 100 |
| 1847 – 2052 | 68 |
| 2052 – 2257 | 63 |
| 2257 – 2463 | 42 |
| 2463 – 2668 | 36 |
| 2668 – 2873 | 22 |
| 2873 – 3078 | 19 |
| 3078 – 3284 | 17 |
| 3284 – 3489 | 6 |
| 3489 – 3694 | 5 |
| 3694 – 3899 | 4 |
| 3899 – 4104 | 6 |
| 4104 – 4310 | 5 |
| 4310 – 4515 | 3 |
| 4515 – 4720 | 1 |
| 4720 – 4925 | 0 |
| 4925 – 5131 | 1 |
| 5131 – 5336 | 1 |
| 5336 – 5541 | 0 |
| 5541 – 5746 | 0 |
| 5746 – 5952 | 0 |
| 5952 – 6157 | 0 |
| 6157 – 6362 | 0 |
| 6362 – 6567 | 0 |
| 6567 – 6772 | 0 |
| 6772 – 6978 | 0 |
| 6978 – 7183 | 0 |
| 7183 – 7388 | 0 |
| 7388 – 7593 | 0 |
| 7593 – 7799 | 0 |
| 7799 – 8004 | 0 |
| 8004 – 8209 | 1 |
This column holds fully-qualified Census tract names for New York City, with every one of the 2327 rows unique and non-null. Lengths cluster tightly between 38 and 46 characters and every record contains the tokens 'new', 'york', 'census', 'tract', and 'county;', with the borough breakdown skewed toward Kings (805) and Queens (725) over Bronx (361) and Richmond (126) — Manhattan/New York County appears absent from the top words, which is worth checking. With n_unique == n, this is effectively a row identifier rather than a feature.
Treatment: Treat as a row label; parse out the borough token if a geographic feature is needed, otherwise drop from modelling.
saturn.columns["NAME"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 2,327 |
| len_min | 38 |
| len_max | 46 |
| len_mean | 41.65 |
| len_median | 41 |
| len_p95 | 46 |
| word_mean | 7.133 |
| word_median | 7 |
| n_empty | 0 |
| n_duplicates | 0 |
| duplicate_rate | 0 |
| vocab_size | 1,539 |
| readability_flesch_mean | 91.45 |
| emoji_rate | 0 |
| url_rate | 0 |
| one_word_rate | 0 |
| allcaps_rate | 0 |
| boilerplate_rate | 0 |
| alert: near_unique | 100.0% of rows are unique strings |
NAME.
| chars | count |
|---|---|
| 38 – 38 | 7 |
| 38 – 38 | 0 |
| 38 – 39 | 0 |
| 39 – 39 | 0 |
| 39 – 39 | 0 |
| 39 – 39 | 104 |
| 39 – 39 | 0 |
| 39 – 40 | 0 |
| 40 – 40 | 0 |
| 40 – 40 | 0 |
| 40 – 40 | 785 |
| 40 – 40 | 0 |
| 40 – 41 | 0 |
| 41 – 41 | 0 |
| 41 – 41 | 0 |
| 41 – 41 | 447 |
| 41 – 41 | 0 |
| 41 – 42 | 0 |
| 42 – 42 | 0 |
| 42 – 42 | 0 |
| 42 – 42 | 200 |
| 42 – 42 | 0 |
| 42 – 43 | 0 |
| 43 – 43 | 0 |
| 43 – 43 | 0 |
| 43 – 43 | 378 |
| 43 – 43 | 0 |
| 43 – 44 | 0 |
| 44 – 44 | 0 |
| 44 – 44 | 0 |
| 44 – 44 | 190 |
| 44 – 44 | 0 |
| 44 – 45 | 0 |
| 45 – 45 | 0 |
| 45 – 45 | 0 |
| 45 – 45 | 82 |
| 45 – 45 | 0 |
| 45 – 46 | 0 |
| 46 – 46 | 0 |
| 46 – 46 | 134 |
The column 'state' is numeric but holds the single value 36 across all 2327 rows, with zero variance and only one unique value. It carries no information for analysis and is flagged constant.
Treatment: Drop, constant column.
saturn.columns["state"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 1 |
| min | 36 |
| max | 36 |
| mean | 36 |
| median | 36 |
| std | 0 |
| q1 | 36 |
| q3 | 36 |
| iqr | 0 |
| skew | 0 |
| kurtosis | 0 |
| n_outliers | 0 |
| outlier_rate | 0 |
| zero_rate | 0 |
| alert: constant | only one distinct value |
state. Vertical dash marks the median.
| bin | count |
|---|---|
| 35.5 – 35.52 | 0 |
| 35.52 – 35.55 | 0 |
| 35.55 – 35.58 | 0 |
| 35.58 – 35.6 | 0 |
| 35.6 – 35.62 | 0 |
| 35.62 – 35.65 | 0 |
| 35.65 – 35.67 | 0 |
| 35.67 – 35.7 | 0 |
| 35.7 – 35.73 | 0 |
| 35.73 – 35.75 | 0 |
| 35.75 – 35.77 | 0 |
| 35.77 – 35.8 | 0 |
| 35.8 – 35.83 | 0 |
| 35.83 – 35.85 | 0 |
| 35.85 – 35.88 | 0 |
| 35.88 – 35.9 | 0 |
| 35.9 – 35.92 | 0 |
| 35.92 – 35.95 | 0 |
| 35.95 – 35.98 | 0 |
| 35.98 – 36 | 0 |
| 36 – 36.02 | 2327 |
| 36.02 – 36.05 | 0 |
| 36.05 – 36.08 | 0 |
| 36.08 – 36.1 | 0 |
| 36.1 – 36.12 | 0 |
| 36.12 – 36.15 | 0 |
| 36.15 – 36.17 | 0 |
| 36.17 – 36.2 | 0 |
| 36.2 – 36.23 | 0 |
| 36.23 – 36.25 | 0 |
| 36.25 – 36.27 | 0 |
| 36.27 – 36.3 | 0 |
| 36.3 – 36.33 | 0 |
| 36.33 – 36.35 | 0 |
| 36.35 – 36.38 | 0 |
| 36.38 – 36.4 | 0 |
| 36.4 – 36.42 | 0 |
| 36.42 – 36.45 | 0 |
| 36.45 – 36.48 | 0 |
| 36.48 – 36.5 | 0 |
Encoded as numeric but only 5 distinct values across 2327 rows (min 5, max 85, median 47), this is almost certainly a categorical county code stored as an integer. The distribution is left-skewed (skew -0.72) with mean 55 sitting above median 47, suggesting one or two higher-numbered codes dominate. No nulls or outliers reported.
Treatment: Cast to categorical and one-hot or target-encode rather than treating as continuous.
saturn.columns["county"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 5 |
| min | 5 |
| max | 85 |
| mean | 55 |
| median | 47 |
| std | 25.97 |
| q1 | 47 |
| q3 | 81 |
| iqr | 34 |
| skew | -0.72 |
| kurtosis | -0.4531 |
| n_outliers | 0 |
| outlier_rate | 0 |
| zero_rate | 0 |
county. Vertical dash marks the median.
| bin | count |
|---|---|
| 5 – 7 | 361 |
| 7 – 9 | 0 |
| 9 – 11 | 0 |
| 11 – 13 | 0 |
| 13 – 15 | 0 |
| 15 – 17 | 0 |
| 17 – 19 | 0 |
| 19 – 21 | 0 |
| 21 – 23 | 0 |
| 23 – 25 | 0 |
| 25 – 27 | 0 |
| 27 – 29 | 0 |
| 29 – 31 | 0 |
| 31 – 33 | 0 |
| 33 – 35 | 0 |
| 35 – 37 | 0 |
| 37 – 39 | 0 |
| 39 – 41 | 0 |
| 41 – 43 | 0 |
| 43 – 45 | 0 |
| 45 – 47 | 0 |
| 47 – 49 | 805 |
| 49 – 51 | 0 |
| 51 – 53 | 0 |
| 53 – 55 | 0 |
| 55 – 57 | 0 |
| 57 – 59 | 0 |
| 59 – 61 | 0 |
| 61 – 63 | 310 |
| 63 – 65 | 0 |
| 65 – 67 | 0 |
| 67 – 69 | 0 |
| 69 – 71 | 0 |
| 71 – 73 | 0 |
| 73 – 75 | 0 |
| 75 – 77 | 0 |
| 77 – 79 | 0 |
| 79 – 81 | 0 |
| 81 – 83 | 725 |
| 83 – 85 | 126 |
Census tract codes stored as integers, ranging from 100 to 990100 across 1530 distinct values in 2327 rows. The skew of 10.14 and kurtosis of 189.8 are artefacts of the tract numbering scheme rather than a real distribution — these are categorical identifiers, not measurements. 63 outliers (2.7%) reflect tracts with unusually high numeric codes, not anomalous data.
Treatment: Treat as categorical geographic key; do not use as a numeric feature or apply transforms.
saturn.columns["tract"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 1,530 |
| min | 100 |
| max | 990,100 |
| mean | 4.225e+04 |
| median | 30,100 |
| std | 4.827e+04 |
| q1 | 15,200 |
| q3 | 5.79e+04 |
| iqr | 4.27e+04 |
| skew | 10.14 |
| kurtosis | 189.8 |
| n_outliers | 63 |
| outlier_rate | 0.02707 |
| zero_rate | 0 |
| alert: high_skew | skew=+10.14 |
tract. Vertical dash marks the median.
| bin | count |
|---|---|
| 100 – 2.485e+04 | 982 |
| 2.485e+04 – 4.96e+04 | 617 |
| 4.96e+04 – 7.435e+04 | 329 |
| 7.435e+04 – 9.91e+04 | 197 |
| 9.91e+04 – 1.238e+05 | 145 |
| 1.238e+05 – 1.486e+05 | 37 |
| 1.486e+05 – 1.734e+05 | 17 |
| 1.734e+05 – 1.981e+05 | 0 |
| 1.981e+05 – 2.228e+05 | 0 |
| 2.228e+05 – 2.476e+05 | 0 |
| 2.476e+05 – 2.724e+05 | 0 |
| 2.724e+05 – 2.971e+05 | 0 |
| 2.971e+05 – 3.218e+05 | 0 |
| 3.218e+05 – 3.466e+05 | 0 |
| 3.466e+05 – 3.714e+05 | 0 |
| 3.714e+05 – 3.961e+05 | 0 |
| 3.961e+05 – 4.208e+05 | 0 |
| 4.208e+05 – 4.456e+05 | 0 |
| 4.456e+05 – 4.704e+05 | 0 |
| 4.704e+05 – 4.951e+05 | 0 |
| 4.951e+05 – 5.198e+05 | 0 |
| 5.198e+05 – 5.446e+05 | 0 |
| 5.446e+05 – 5.694e+05 | 0 |
| 5.694e+05 – 5.941e+05 | 0 |
| 5.941e+05 – 6.188e+05 | 0 |
| 6.188e+05 – 6.436e+05 | 0 |
| 6.436e+05 – 6.684e+05 | 0 |
| 6.684e+05 – 6.931e+05 | 0 |
| 6.931e+05 – 7.178e+05 | 0 |
| 7.178e+05 – 7.426e+05 | 0 |
| 7.426e+05 – 7.674e+05 | 0 |
| 7.674e+05 – 7.921e+05 | 0 |
| 7.921e+05 – 8.168e+05 | 0 |
| 8.168e+05 – 8.416e+05 | 0 |
| 8.416e+05 – 8.664e+05 | 0 |
| 8.664e+05 – 8.911e+05 | 0 |
| 8.911e+05 – 9.158e+05 | 0 |
| 9.158e+05 – 9.406e+05 | 0 |
| 9.406e+05 – 9.654e+05 | 0 |
| 9.654e+05 – 9.901e+05 | 3 |
This column lists New York City borough/county names across 2327 rows, with all 5 NYC boroughs represented and no nulls. Distribution is fairly even (entropy ratio 0.898), though Brooklyn (Kings) leads at 34.6% (805) and Staten Island (Richmond) trails at 126. The parenthetical county names suggest the source schema uses formal county labels rather than borough-only naming.
Treatment: one-hot or target-encode for modelling.
saturn.columns["county_name"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 0 (0.0%) |
| unique | 5 |
| top_value | Brooklyn (Kings) |
| top_rate | 0.3459 |
| cardinality | 5 |
| entropy | 2.086 |
| entropy_ratio | 0.8985 |
county_name.
| value | count | share |
|---|---|---|
| Brooklyn (Kings) | 805 | 34.6% |
| Queens | 725 | 31.2% |
| Bronx | 361 | 15.5% |
| Manhattan (New York) | 310 | 13.3% |
| Staten Island (Richmond) | 126 | 5.4% |
Numeric column on a 0-100 scale (min 0.0, max 100.0) capturing the percentage of owner-occupied housing per record. The distribution is wide and flattish (std 25.65, kurtosis -0.85) with mean 37.51 just above median 34.4, and a broad IQR from 16.4 to 56.1, indicating most areas are minority owner-occupied. About 4.13% of rows are null and 3.23% are exactly zero, which may represent fully-rental areas worth flagging.
Treatment: Impute the 4.13% nulls and use as-is; no transform needed given mild skew (0.39) and no outliers.
saturn.columns["pct_owner_occupied"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 96 (4.1%) |
| unique | 823 |
| min | 0 |
| max | 100 |
| mean | 37.51 |
| median | 34.4 |
| std | 25.65 |
| q1 | 16.4 |
| q3 | 56.1 |
| iqr | 39.7 |
| skew | 0.3948 |
| kurtosis | -0.854 |
| n_outliers | 0 |
| outlier_rate | 0 |
| zero_rate | 0.03227 |
pct_owner_occupied. Vertical dash marks the median.
| bin | count |
|---|---|
| 0 – 2.5 | 141 |
| 2.5 – 5 | 86 |
| 5 – 7.5 | 71 |
| 7.5 – 10 | 63 |
| 10 – 12.5 | 86 |
| 12.5 – 15 | 65 |
| 15 – 17.5 | 72 |
| 17.5 – 20 | 88 |
| 20 – 22.5 | 98 |
| 22.5 – 25 | 88 |
| 25 – 27.5 | 79 |
| 27.5 – 30 | 67 |
| 30 – 32.5 | 70 |
| 32.5 – 35 | 56 |
| 35 – 37.5 | 76 |
| 37.5 – 40 | 68 |
| 40 – 42.5 | 59 |
| 42.5 – 45 | 72 |
| 45 – 47.5 | 58 |
| 47.5 – 50 | 54 |
| 50 – 52.5 | 70 |
| 52.5 – 55 | 59 |
| 55 – 57.5 | 55 |
| 57.5 – 60 | 39 |
| 60 – 62.5 | 44 |
| 62.5 – 65 | 40 |
| 65 – 67.5 | 52 |
| 67.5 – 70 | 34 |
| 70 – 72.5 | 40 |
| 72.5 – 75 | 47 |
| 75 – 77.5 | 32 |
| 77.5 – 80 | 48 |
| 80 – 82.5 | 31 |
| 82.5 – 85 | 27 |
| 85 – 87.5 | 26 |
| 87.5 – 90 | 24 |
| 90 – 92.5 | 23 |
| 92.5 – 95 | 8 |
| 95 – 97.5 | 6 |
| 97.5 – 100 | 9 |
Numeric share variable bounded between 0 and 100 (mean 62.49, median 65.6) — almost certainly the percentage of renter-occupied housing units in each row. The distribution is wide (std 25.65, IQR 39.7) and slightly left-skewed (skew -0.39, kurtosis -0.85), so values cluster toward the high end with a long tail of owner-dominated areas. About 4.13% of rows are null and only 0.27% are exact zeros; no outliers were flagged given the natural 0–100 bounds.
Treatment: Impute the ~4% nulls and use as-is, or rescale to 0–1 before modelling.
saturn.columns["pct_renter_occupied"].stats
| stat | value |
|---|---|
| n | 2,327 |
| nulls | 96 (4.1%) |
| unique | 823 |
| min | 0 |
| max | 100 |
| mean | 62.49 |
| median | 65.6 |
| std | 25.65 |
| q1 | 43.9 |
| q3 | 83.6 |
| iqr | 39.7 |
| skew | -0.3948 |
| kurtosis | -0.854 |
| n_outliers | 0 |
| outlier_rate | 0 |
| zero_rate | 0.002689 |
pct_renter_occupied. Vertical dash marks the median.
| bin | count |
|---|---|
| 0 – 2.5 | 9 |
| 2.5 – 5 | 6 |
| 5 – 7.5 | 7 |
| 7.5 – 10 | 23 |
| 10 – 12.5 | 24 |
| 12.5 – 15 | 26 |
| 15 – 17.5 | 27 |
| 17.5 – 20 | 32 |
| 20 – 22.5 | 47 |
| 22.5 – 25 | 31 |
| 25 – 27.5 | 48 |
| 27.5 – 30 | 40 |
| 30 – 32.5 | 34 |
| 32.5 – 35 | 50 |
| 35 – 37.5 | 39 |
| 37.5 – 40 | 46 |
| 40 – 42.5 | 41 |
| 42.5 – 45 | 53 |
| 45 – 47.5 | 57 |
| 47.5 – 50 | 72 |
| 50 – 52.5 | 54 |
| 52.5 – 55 | 54 |
| 55 – 57.5 | 73 |
| 57.5 – 60 | 62 |
| 60 – 62.5 | 69 |
| 62.5 – 65 | 72 |
| 65 – 67.5 | 60 |
| 67.5 – 70 | 65 |
| 70 – 72.5 | 72 |
| 72.5 – 75 | 75 |
| 75 – 77.5 | 91 |
| 77.5 – 80 | 94 |
| 80 – 82.5 | 92 |
| 82.5 – 85 | 73 |
| 85 – 87.5 | 64 |
| 87.5 – 90 | 83 |
| 90 – 92.5 | 65 |
| 92.5 – 95 | 71 |
| 95 – 97.5 | 83 |
| 97.5 – 100 | 147 |
click to copy
@misc{saturn-nyc-housing-nyc-tenure-by-tract-2026,
author = {Steuber, Luke},
title = {Saturn reading: nyc housing nyc tenure by tract},
year ={2026},
howpublished = {\url{https://dr.eamer.dev/saturn/view/nyc_housing-nyc_tenure_by_tract}},
note = {Profiled with saturn-dissect v0.2.0, prompt saturn-insight-v2, model anthropic:claude-opus-4-7},
}
Steuber, L. (2026). Saturn reading: nyc housing nyc tenure by tract. Source: /home/coolhand/html/datavis/data_trove/data/urban/nyc_housing/nyc_tenure_by_tract.csv. Profiled with saturn-dissect v0.2.0 (saturn-insight-v2, anthropic:claude-opus-4-7). Retrieved from https://dr.eamer.dev/saturn/view/nyc_housing-nyc_tenure_by_tract