PySuricata EDA Report — Bike Sharing

Generated 2026-08-20 10:00:23 Profiled in 0.31 s Shape 17,379 rows × 12 columns pysuricata 0.2.0

Summary

Rows
17,379
single pass
Columns
12
7 num · 2 cat · 1 date · 2 bool
Missing
0.0%
0 cells
Duplicates
< 585
below sketch resolution
Processed
1.5 MB
across all chunks
Elapsed
0.31 s
wall clock
Column types
Top missing columns
  • No column has missing values

12 of 12 columns are complete

1 unique · 0 constant · 0 high-cardinality · 2 text (avg len 5.6) · range 2011-01-01 00:00:00 UTC → 2012-12-31 23:00:00 UTC

Description
+ add a note

Sample

Hide sample

12 cols · scroll →10 rows drawn at random from the first chunk

rented_atseasonweatherholidayworking_daytempfeels_likehumiditywindspeedcasualregisteredrentals
61242011-09-17 18:00:00summermistFalseFalse0.520.50.720.2295234329
26002011-04-23 06:00:00springmistFalseFalse0.340.331.00.1601111
12442011-02-24 23:00:00wintermistFalseTrue0.320.30.930.2234750
49192011-07-28 21:00:00summerclearFalseTrue0.780.760.660.2831165196
16372011-03-13 18:00:00winterclearFalseFalse0.40.410.430.365592147
43902011-07-06 20:00:00summerclearFalseTrue0.720.70.740.2555257312
96162012-02-10 15:00:00wintermistFalseTrue0.320.330.450.1327164191
146522012-09-07 17:00:00summerclearFalseTrue0.780.740.590.3388684772
145132012-09-01 22:00:00summermistFalseFalse0.660.590.890.0215778
2692011-01-12 16:00:00winterclearFalseTrue0.220.20.440.3356368

Variables

5 of 12 columns need a look

  • casual7.57 heavy‑tailed · limit 106.9% many outliers · limit 5%
  • registered3.9% many outliers · limit 5%
  • rentals2.9% many outliers · limit 5%
  • windspeed2.0% many outliers · limit 5%
  • holidayImbalanced
What these flags mean
Only the 3 flags this report raised
FlagWhat is measured Fires aboveWhat it means
heavy tailedExcess kurtosis of the values10The tail is far heavier than a normal distribution, where this is 0. Means and standard deviations are pulled by a few extreme rows.
many outliersShare beyond 1.5× IQR from the quartiles5%Values outside the usual range. They may be errors or may be real — the Outliers pane lists them so you can tell which.
imbalancedRatio between the largest and smallest class10:1The classes are far apart in size, so a share computed over all of them is dominated by the largest.
rented_at Datetime datetime64[ns]
  • Monotonic ↑
  • Multiple peaks detected
  • High uniqueness

A record every 1.0 hour on average, but the gaps vary widely (± 30.6 minutes) — this is an event stream, not a schedule.

0100200300ROWS
Records over time, 60 intervals
2011-01-012011-07-022012-01-012012-07-022012-12-31
60 intervals · peak 293 rows at 2011-05-02
Shape of the calendar
Weekend share28.9%
flat · +0.3pp vs 28.6%
Business hours23.9%
flat · +0.0pp vs 23.8%
rule marks the flat-calendar share — 2 of 7 days, and 8 of 24 hours on 5 of 7 days
Count
17,379
Unique (≈)
17,379
Missing
0 (0.0%)
Timezone
— (naive)
Time span
2.0 years
Min
2011-01-01 00:00:00
Max
2012-12-31 23:00:00
Data density
23.8 records/day
season Categorical object
summer 4,496 rows (25.9%)summer4,496 (25.9%)spring 4,409 rows (25.4%)spring4,409 (25.4%)winter 4,242 rows (24.4%)winter4,242 (24.4%)autumn 4,232 rows (24.4%)autumn4,232 (24.4%)

4 of 4 levels shown · covers 100% of the 17,379 non-missing rows · rule at 25%, an even split

Count
17,379
Unique
4
Missing
0 (0.0%)
Mode
summer
Mode %
25.9%
Empty or zero
0
Entropy
2
Rare levels
0 (0.0%)
Label length (avg)
6
Length p90
6
Processed bytes (≈)
237.6 KB
weather Categorical object
clear 11,413 rows (65.7%)clear11,413 (65.7%)mist 4,544 rows (26.1%)mist4,544 (26.1%)light rain 1,419 rows (8.2%)light rain1,419 (8.2%)heavy rain 3 rows (0.0%)heavy rain3 (0.0%)

4 of 4 levels shown · covers 100% of the 17,379 non-missing rows · rule at 25%, an even split

Count
17,379
Unique
4
Missing
0 (0.0%)
Mode
clear
Mode %
65.7%
Empty or zero
0
Entropy
1.202
Rare levels
1 (0.0%)
Label length (avg)
5.148
Length p90
5
Processed bytes (≈)
222.7 KB
holiday Boolean bool
  • Imbalanced
False: 16,879 (97.1%)false 97.1%True: 500 (2.9%)Missing: 0 (0.0%)
Count
17,379
Missing
0 (0.0%)
Unique
2
True
500 (2.9%)
False
16,879 (97.1%)
Processed bytes (≈)
17.0 KB
working_day Boolean bool
False: 5,514 (31.7%)false 31.7%True: 11,865 (68.3%)true 68.3%Missing: 0 (0.0%)
Count
17,379
Missing
0 (0.0%)
Unique
2
True
11,865 (68.3%)
False
5,514 (31.7%)
Processed bytes (≈)
17.0 KB
temp Numeric float64
  • Positive‑only
01000200030004000ROWS
Histogram for tempDistribution chart with 10 bins
0.0200.1420.2650.3880.5100.6330.7550.8771
10 bins · peak 3,090 rows at 0.608–0.706
02000400060008000ROWS
Histogram for temp (log scale)Distribution chart with 10 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
10 bins · peak 6,121 rows at 0.457–0.676
050010001500ROWS
Histogram for tempDistribution chart with 25 bins
0.0200.1420.2650.3880.5100.6330.7550.8771
25 bins · peak 1,418 rows at 0.608–0.647
01000200030004000ROWS
Histogram for temp (log scale)Distribution chart with 25 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
25 bins · peak 3,217 rows at 0.625–0.731
0200400600800ROWS
Histogram for tempDistribution chart with 50 bins
0.0200.1420.2650.3880.5100.6330.7550.8771
50 bins · peak 709 rows at 0.608–0.628
0500100015002000ROWS
Histogram for temp (log scale)Distribution chart with 50 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
50 bins · peak 1,659 rows at 0.676–0.731
statistics · 50 common values · 5 lowest and highest · no outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
50
Missing
0 (0.0%)
Outliers
0 (0.0%)
Zeros
0 (0.0%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0.02
Q1 (P25)
0.34
Median
0.5
Mean
0.497
Q3 (P75)
0.66
Max
1
feels_like Numeric float64 approx
01000200030004000ROWS
Histogram for feels_likeDistribution chart with 10 bins
00.1250.2500.3750.5000.6250.7500.8751
10 bins · peak 3,659 rows at 0.600–0.700
02000400060008000ROWS
Histogram for feels_like (log scale)Distribution chart with 10 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
10 bins · peak 7,478 rows at 0.457–0.676 · 2 rows not shown (≤ 0)
0500100015002000ROWS
Histogram for feels_likeDistribution chart with 25 bins
00.1250.2500.3750.5000.6250.7500.8751
25 bins · peak 1,689 rows at 0.520–0.560
01000200030004000ROWS
Histogram for feels_like (log scale)Distribution chart with 25 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
25 bins · peak 3,299 rows at 0.625–0.731 · 2 rows not shown (≤ 0)
02004006008001000ROWS
Histogram for feels_likeDistribution chart with 50 bins
00.1250.2500.3750.5000.6250.7500.8751
50 bins · peak 845 rows at 0.520–0.540
0500100015002000ROWS
Histogram for feels_like (log scale)Distribution chart with 50 bins
0.0200.0330.0530.0870.1410.2310.3760.6131
50 bins · peak 1,966 rows at 0.625–0.676 · 2 rows not shown (≤ 0)
statistics · 49 common values · 5 lowest and highest · no outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
65
Missing
0 (0.0%)
Outliers
0 (0.0%)
Zeros
2 (0.0%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0
Q1 (P25)
0.33
Median
0.48
Mean
0.4758
Q3 (P75)
0.62
Max
1
humidity Numeric float64 approx
0100020003000ROWS
Histogram for humidityDistribution chart with 10 bins
00.1250.2500.3750.5000.6250.7500.8751
10 bins · peak 2,837 rows at 0.500–0.600
02000400060008000ROWS
Histogram for humidity (log scale)Distribution chart with 10 bins
0.0400.0600.0890.1340.2000.2990.4470.6691
10 bins · peak 6,137 rows at 0.725–1 · 22 rows not shown (≤ 0)
050010001500ROWS
Histogram for humidityDistribution chart with 25 bins
00.1250.2500.3750.5000.6250.7500.8751
25 bins · peak 1,311 rows at 0.800–0.840
0100020003000ROWS
Histogram for humidity (log scale)Distribution chart with 25 bins
0.0400.0600.0890.1340.2000.2990.4470.6691
25 bins · peak 2,742 rows at 0.773–0.879 · 22 rows not shown (≤ 0)
0200400600800ROWS
Histogram for humidityDistribution chart with 50 bins
00.1250.2500.3750.5000.6250.7500.8751
50 bins · peak 656 rows at 0.800–0.820
0500100015002000ROWS
Histogram for humidity (log scale)Distribution chart with 50 bins
0.0400.0600.0890.1340.2000.2990.4470.6691
50 bins · peak 1,557 rows at 0.773–0.824 · 22 rows not shown (≤ 0)
statistics · 48 common values · 5 lowest and highest · 22 outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
89
Missing
0 (0.0%)
Outliers
22 (0.1%)
Zeros
22 (0.1%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0
Q1 (P25)
0.48
Median
0.63
Mean
0.6272
Q3 (P75)
0.78
Max
1
windspeed Numeric float64
  • 2.0% many outliers · limit 5%
010002000300040005000ROWS
Histogram for windspeedDistribution chart with 10 bins
00.1060.2120.3190.4250.5310.6370.7440.850
10 bins · peak 4,954 rows at 0.085–0.170
01000200030004000ROWS
Histogram for windspeed (log scale)Distribution chart with 10 bins
0.0340.0510.0760.1140.1700.2540.3800.5680.850
10 bins · peak 3,616 rows at 0.234–0.324 · 2,180 rows not shown (≤ 0)
01000200030004000ROWS
Histogram for windspeedDistribution chart with 25 bins
00.1060.2120.3190.4250.5310.6370.7440.850
25 bins · peak 3,042 rows at 0.068–0.102
0500100015002000ROWS
Histogram for windspeed (log scale)Distribution chart with 25 bins
0.0340.0510.0760.1140.1700.2540.3800.5680.850
25 bins · peak 1,910 rows at 0.267–0.303 · 2,180 rows not shown (≤ 0)
0500100015002000ROWS
Histogram for windspeedDistribution chart with 50 bins
00.1060.2120.3190.4250.5310.6370.7440.850
50 bins · peak 1,521 rows at 0.068–0.085
050010001500ROWS
Histogram for windspeed (log scale)Distribution chart with 50 bins
0.0340.0510.0760.1140.1700.2540.3800.5680.850
50 bins · peak 1,015 rows at 0.284–0.303 · 2,180 rows not shown (≤ 0)
statistics · 30 common values · 5 lowest and highest · 342 outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
30
Missing
0 (0.0%)
Outliers
342 (2.0%)
Zeros
2,180 (12.5%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0
Q1 (P25)
0.1
Median
0.19
Mean
0.1879
Q3 (P75)
0.25
Max
0.85
casual Numeric int64 approx
  • 2.50 skewed Right · limit ±2
  • 7.57 heavy‑tailed · limit 10
  • 6.9% many outliers · limit 5%
0500010K15KROWS
Histogram for casualDistribution chart with 10 bins
045.991.8137.6183.5229.4275.2321.1367
10 bins · peak 11,810 rows at 0–36.7
0100020003000ROWS
Histogram for casual (log scale)Distribution chart with 10 bins
12.14.49.219.240.183.8175.4367
10 bins · peak 2,502 rows at 34.6–62.4 · 1,581 rows not shown (≤ 0)
0200040006000800010KROWS
Histogram for casualDistribution chart with 25 bins
045.991.8137.6183.5229.4275.2321.1367
25 bins · peak 8,228 rows at 0–14.7
050010001500ROWS
Histogram for casual (log scale)Distribution chart with 25 bins
12.14.49.219.240.183.8175.4367
25 bins · peak 1,031 rows at 34.6–43.8 · 1,581 rows not shown (≤ 0)
010002000300040005000ROWS
Histogram for casualDistribution chart with 50 bins
045.991.8137.6183.5229.4275.2321.1367
50 bins · peak 4,114 rows at 0–7.3
0200400600ROWS
Histogram for casual (log scale)Distribution chart with 50 bins
12.14.49.219.240.183.8175.4367
50 bins · peak 515 rows at 30.7–34.6 · 1,581 rows not shown (≤ 0)
statistics · 32 common values · 5 lowest and highest · 1,192 outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
322
Missing
0 (0.0%)
Outliers
1,192 (6.9%)
Zeros
1,581 (9.1%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0
Q1 (P25)
4
Median
17
Mean
35.68
Q3 (P75)
48
Max
367
registered Numeric int64 approx
  • 1.56 skewed Right · limit ±2
  • 3.9% many outliers · limit 5%
02000400060008000ROWS
Histogram for registeredDistribution chart with 10 bins
0110.8221.5332.2443553.8664.5775.2886
10 bins · peak 7,271 rows at 0–88.6
010002000300040005000ROWS
Histogram for registered (log scale)Distribution chart with 10 bins
12.35.512.729.869.5162.4379.3886
10 bins · peak 4,590 rows at 115.7–228.0 · 24 rows not shown (≤ 0)
010002000300040005000ROWS
Histogram for registeredDistribution chart with 25 bins
0110.8221.5332.2443553.8664.5775.2886
25 bins · peak 4,431 rows at 0–35.4
0500100015002000ROWS
Histogram for registered (log scale)Distribution chart with 25 bins
12.35.512.729.869.5162.4379.3886
25 bins · peak 1,896 rows at 173.8–228.0 · 24 rows not shown (≤ 0)
0100020003000ROWS
Histogram for registeredDistribution chart with 50 bins
0110.8221.5332.2443553.8664.5775.2886
50 bins · peak 2,216 rows at 0–17.7
02004006008001000ROWS
Histogram for registered (log scale)Distribution chart with 50 bins
12.35.512.729.869.5162.4379.3886
50 bins · peak 987 rows at 151.7–173.8 · 24 rows not shown (≤ 0)
statistics · 33 common values · 5 lowest and highest · 680 outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
776
Missing
0 (0.0%)
Outliers
680 (3.9%)
Zeros
24 (0.1%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
0
Q1 (P25)
34
Median
115
Mean
153.8
Q3 (P75)
220
Max
886
rentals Numeric int64 approx
  • Positive‑only
  • 1.28 skewed Right · limit ±2
  • Log‑scale?
  • 2.9% many outliers · limit 5%
02000400060008000ROWS
Histogram for rentalsDistribution chart with 10 bins
1123245367489611733855977
10 bins · peak 6,979 rows at 1–98.6
010002000300040005000ROWS
Histogram for rentals (log scale)Distribution chart with 10 bins
12.45.613.231.373.9174.8413.2977
10 bins · peak 4,193 rows at 123.9–246.6
010002000300040005000ROWS
Histogram for rentalsDistribution chart with 25 bins
1123245367489611733855977
25 bins · peak 4,377 rows at 1–40.0
0500100015002000ROWS
Histogram for rentals (log scale)Distribution chart with 25 bins
12.45.613.231.373.9174.8413.2977
25 bins · peak 1,838 rows at 187.2–246.6
0100020003000ROWS
Histogram for rentalsDistribution chart with 50 bins
1123245367489611733855977
50 bins · peak 2,189 rows at 1–20.5
02004006008001000ROWS
Histogram for rentals (log scale)Distribution chart with 50 bins
12.45.613.231.373.9174.8413.2977
50 bins · peak 919 rows at 187.2–214.8
statistics · 30 common values · 5 lowest and highest · 505 outliers · 6 correlations
Scale:
Bins:
Count
17,379
Unique
869
Missing
0 (0.0%)
Outliers
505 (2.9%)
Zeros
0 (0.0%)
Infinites
0 (0.0%)
Negatives
0 (0.0%)
Min
1
Q1 (P25)
40
Median
142
Mean
189.5
Q3 (P75)
281
Max
977

Correlations

Correlation Analysis

4 pairs above 0.50, of 21 checked
tempfeels_likehumiditywindspeedcasualregistered
feels_like+0.99
humidity-0.07-0.05
windspeed-0.02-0.06-0.29
casual+0.46+0.45-0.35+0.09
registered+0.34+0.33-0.27+0.08+0.51
rentals+0.40+0.40-0.32+0.09+0.69+0.97

Missing Values

All 12 columns are complete

No missing values in any of the 12 columns.