{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Load data from a CSV file\n", "\n", "These examples illustrate how to load data from a CSV file using the Pandas and GeoPandas libraries." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## From latitude and longitude columns" ] }, { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | incident_datetime | \n", "incident_date | \n", "incident_time | \n", "incident_year | \n", "incident_day_of_week | \n", "report_datetime | \n", "row_id | \n", "incident_id | \n", "incident_number | \n", "cad_number | \n", "... | \n", ":@computed_region_qgnn_b9vv | \n", ":@computed_region_26cr_cadq | \n", ":@computed_region_ajp5_b2md | \n", ":@computed_region_nqbw_i6c3 | \n", ":@computed_region_2dwj_jsy4 | \n", ":@computed_region_h4ep_8xdi | \n", ":@computed_region_y6ts_4iup | \n", ":@computed_region_jg9y_a9du | \n", ":@computed_region_6pnf_4xz7 | \n", "geometry | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2019-05-01T01:00:00.000 | \n", "2019-05-01T00:00:00.000 | \n", "01:00 | \n", "2019 | \n", "Wednesday | \n", "2019-06-12T20:27:00.000 | \n", "81097515200 | \n", "810975 | \n", "190424067 | \n", "191634131.0 | \n", "... | \n", "10.0 | \n", "7.0 | \n", "35.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.0 | \n", "POINT (-122.49963 37.76257) | \n", "
| 1 | \n", "2019-06-22T07:45:00.000 | \n", "2019-06-22T00:00:00.000 | \n", "07:45 | \n", "2019 | \n", "Saturday | \n", "2019-06-22T08:05:00.000 | \n", "81465564020 | \n", "814655 | \n", "190450880 | \n", "191730737.0 | \n", "... | \n", "1.0 | \n", "10.0 | \n", "34.0 | \n", "1.0 | \n", "NaN | \n", "1.0 | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.40816 37.78054) | \n", "
| 2 | \n", "2019-06-03T16:16:00.000 | \n", "2019-06-03T00:00:00.000 | \n", "16:16 | \n", "2019 | \n", "Monday | \n", "2019-06-03T16:16:00.000 | \n", "80769875000 | \n", "807698 | \n", "190397016 | \n", "191533509.0 | \n", "... | \n", "2.0 | \n", "9.0 | \n", "1.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.39075 37.72160) | \n", "
| 3 | \n", "2018-11-16T16:34:00.000 | \n", "2018-11-16T00:00:00.000 | \n", "16:34 | \n", "2018 | \n", "Friday | \n", "2018-11-16T16:34:00.000 | \n", "73857915041 | \n", "738579 | \n", "180870806 | \n", "183202539.0 | \n", "... | \n", "6.0 | \n", "3.0 | \n", "6.0 | \n", "NaN | \n", "18.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.40488 37.79486) | \n", "
| 4 | \n", "2019-05-27T02:25:00.000 | \n", "2019-05-27T00:00:00.000 | \n", "02:25 | \n", "2019 | \n", "Monday | \n", "2019-05-27T02:55:00.000 | \n", "80509204134 | \n", "805092 | \n", "190378555 | \n", "191470256.0 | \n", "... | \n", "4.0 | \n", "6.0 | \n", "13.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.0 | \n", "POINT (-122.43056 37.79772) | \n", "
5 rows × 37 columns
\n", "| \n", " | the_geom | \n", "cartodb_id | \n", "field_1 | \n", "name | \n", "address | \n", "revenue | \n", "id_store | \n", "geometry | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "0101000020E61000005EA27A6B607D52C01956F146E655... | \n", "1 | \n", "0 | \n", "Franklin Ave & Eastern Pkwy | \n", "341 Eastern Pkwy,Brooklyn, NY 11238 | \n", "1321040.772 | \n", "A | \n", "POINT (-73.95901 40.67109) | \n", "
| 1 | \n", "0101000020E6100000B610E4A0847D52C0B532E197FA49... | \n", "2 | \n", "1 | \n", "607 Brighton Beach Ave | \n", "607 Brighton Beach Avenue,Brooklyn, NY 11235 | \n", "1268080.418 | \n", "B | \n", "POINT (-73.96122 40.57796) | \n", "
| 2 | \n", "0101000020E6100000E5B8533A587F52C05726FC523F4F... | \n", "3 | \n", "2 | \n", "65th St & 18th Ave | \n", "6423 18th Avenue,Brooklyn, NY 11204 | \n", "1248133.699 | \n", "C | \n", "POINT (-73.98976 40.61912) | \n", "
| 3 | \n", "0101000020E61000008BA6B393C18152C08D62B9A5D550... | \n", "4 | \n", "3 | \n", "Bay Ridge Pkwy & 3rd Ave | \n", "7419 3rd Avenue,Brooklyn, NY 11209 | \n", "1185702.676 | \n", "D | \n", "POINT (-74.02744 40.63152) | \n", "
| 4 | \n", "0101000020E6100000CEFC6A0E108052C080D4264EEE4B... | \n", "5 | \n", "4 | \n", "Caesar's Bay Shopping Center | \n", "8973 Bay Parkway,Brooklyn, NY 11214 | \n", "1148427.411 | \n", "E | \n", "POINT (-74.00098 40.59321) | \n", "