{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "## Read data from a CSV file\n", "\n", "These examples illustrate how to read 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", "2020-08-16T03:13:00.000 | \n", "2020-08-16T00:00:00.000 | \n", "03:13 | \n", "2020 | \n", "Sunday | \n", "2020-08-16T03:14:00.000 | \n", "95319604083 | \n", "953196 | \n", "200491669 | \n", "202290313.0 | \n", "... | \n", "2.0 | \n", "9 | \n", "26.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.39773 37.75483) | \n", "
1 | \n", "2020-08-16T03:38:00.000 | \n", "2020-08-16T00:00:00.000 | \n", "03:38 | \n", "2020 | \n", "Sunday | \n", "2020-08-16T04:56:00.000 | \n", "95326228100 | \n", "953262 | \n", "200491738 | \n", "202290404.0 | \n", "... | \n", "3.0 | \n", "2 | \n", "20.0 | \n", "3.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.42204 37.76654) | \n", "
2 | \n", "2020-08-16T13:40:00.000 | \n", "2020-08-16T00:00:00.000 | \n", "13:40 | \n", "2020 | \n", "Sunday | \n", "2020-08-16T13:56:00.000 | \n", "95336264020 | \n", "953362 | \n", "200492463 | \n", "202291631.0 | \n", "... | \n", "1.0 | \n", "10 | \n", "8.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.0 | \n", "POINT (-122.40371 37.78404) | \n", "
3 | \n", "2020-08-16T16:18:00.000 | \n", "2020-08-16T00:00:00.000 | \n", "16:18 | \n", "2020 | \n", "Sunday | \n", "2020-08-16T16:18:00.000 | \n", "95335012010 | \n", "953350 | \n", "200492792 | \n", "202292091.0 | \n", "... | \n", "10.0 | \n", "7 | \n", "35.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "1.0 | \n", "POINT (-122.50742 37.75100) | \n", "
4 | \n", "2020-08-12T22:00:00.000 | \n", "2020-08-12T00:00:00.000 | \n", "22:00 | \n", "2020 | \n", "Wednesday | \n", "2020-08-15T08:30:00.000 | \n", "95300674000 | \n", "953006 | \n", "200489880 | \n", "202280827.0 | \n", "... | \n", "4.0 | \n", "11 | \n", "39.0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "2.0 | \n", "POINT (-122.43214 37.78050) | \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", "