Pandas Practices

this dataset for practices with pandas

@kaggle.melihkanbay_police

Table List

1 table(555.86 KB)

Police

@kaggle.melihkanbay_police.police

555.86 KB
91741 rows
15 columns

stop_date Stop Date	stop_time Stop Time	driver_gender Driver Gender	driver_age_raw Driver Age Raw	driver_age Driver Age	driver_race Driver Race	violation_raw Violation Raw	violation Violation	search_type Search Type	stop_outcome Stop Outcome	is_arrested Is Arrested	stop_duration Stop Duration
Sun Jan 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	01:55	M	1985	20	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Tue Jan 18 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	08:15	M	1965	40	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Sun Jan 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	23:15	M	1972	33	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Sun Feb 20 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	17:15	M	1986	19	White	Call for Service	Other	nan	Arrest Driver	True	16-30 Min
Mon Mar 14 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10:00	F	1984	21	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Wed Mar 23 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	09:45	M	1982	23	Black	Equipment/Inspection Violation	Equipment	nan	Citation	False	0-15 Min
Fri Apr 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30	M	1969	36	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Mon Jun 06 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	13:20	F	1986	19	White	Speeding	Speeding	nan	Citation	False	0-15 Min
Wed Jul 13 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	10:15	M	1970	35	Black	Speeding	Speeding	nan	Citation	False	0-15 Min
Wed Jul 13 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	15:45	M	1970	35	White	Speeding	Speeding	nan	Citation	False	0-15 Min


CREATE TABLE police (
  "stop_date" TIMESTAMP,
  "stop_time" VARCHAR,
  "county_name" VARCHAR,
  "driver_gender" VARCHAR,
  "driver_age_raw" DOUBLE,
  "driver_age" DOUBLE,
  "driver_race" VARCHAR,
  "violation_raw" VARCHAR,
  "violation" VARCHAR,
  "search_conducted" BOOLEAN,
  "search_type" VARCHAR,
  "stop_outcome" VARCHAR,
  "is_arrested" VARCHAR,
  "stop_duration" VARCHAR,
  "drugs_related_stop" BOOLEAN
);