\n",
"\n",
"\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" proj_raster_path \\\n",
"0 https://modis-pds.s3.amazonaws.com/MCD43A4.006... \n",
"1 https://modis-pds.s3.amazonaws.com/MCD43A4.006... \n",
"2 https://modis-pds.s3.amazonaws.com/MCD43A4.006... \n",
"3 https://modis-pds.s3.amazonaws.com/MCD43A4.006... \n",
"\n",
" tile \\\n",
"0 Tile(dimensions=[256, 256], cell_type=CellType... \n",
"1 Tile(dimensions=[256, 256], cell_type=CellType... \n",
"2 Tile(dimensions=[256, 256], cell_type=CellType... \n",
"3 Tile(dimensions=[256, 256], cell_type=CellType... \n",
"\n",
" crs \\\n",
"0 (+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.... \n",
"1 (+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.... \n",
"2 (+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.... \n",
"3 (+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.... \n",
"\n",
" ext \n",
"0 (14455356.755667, -2342509.0947640934, 1457396... \n",
"1 (14573964.811098093, -2342509.0947640934, 1469... \n",
"2 (14692572.866529185, -2342509.0947640934, 1481... \n",
"3 (14811180.92196028, -2342509.0947640934, 14929... "
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pandas_df = df.limit(10).toPandas()\n",
"pandas_df.head(4)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"You still get the default string representatation of a `pandas.Series`"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"proj_raster_path https://modis-pds.s3.amazonaws.com/MCD43A4.006...\n",
"tile Tile(dimensions=[256, 256], cell_type=CellType...\n",
"crs (+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007....\n",
"ext (15404221.199115746, -2342509.0947640934, 1552...\n",
"Name: 8, dtype: object"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pandas_df.iloc[8]"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"scrolled": true
},
"outputs": [
{
"data": {
"text/plain": [
"0 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"1 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"2 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"3 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"4 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"5 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"6 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"7 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"8 Tile(dimensions=[256, 256], cell_type=CellType...\n",
"9 Tile(dimensions=[96, 256], cell_type=CellType(...\n",
"Name: tile, dtype: object"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"pandas_df.tile"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"And nothing different happens for a `pandas.DataFrame` that doesn't have a `Tile` in it."
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"| \n", " | proj_raster_path | \n", "tile | \n", "crs | \n", "ext | \n", "
|---|---|---|---|---|
| 0 | \n", "https://modis-pds.s3.amazonaws.com/MCD43A4.006/31/11/2017158/MCD43A4.A2017158.h31v11.006.2017171203421_B01.TIF | \n", "(+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181 +units=m +no_defs ,) | \n", "(14455356.755667, -2342509.0947640934, 14573964.811098093, -2223901.039333) | \n", "|
| 1 | \n", "https://modis-pds.s3.amazonaws.com/MCD43A4.006/31/11/2017158/MCD43A4.A2017158.h31v11.006.2017171203421_B01.TIF | \n", "(+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181 +units=m +no_defs ,) | \n", "(14573964.811098093, -2342509.0947640934, 14692572.866529187, -2223901.039333) | \n", "|
| 2 | \n", "https://modis-pds.s3.amazonaws.com/MCD43A4.006/31/11/2017158/MCD43A4.A2017158.h31v11.006.2017171203421_B01.TIF | \n", "(+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181 +units=m +no_defs ,) | \n", "(14692572.866529185, -2342509.0947640934, 14811180.921960281, -2223901.039333) | \n", "|
| 3 | \n", "https://modis-pds.s3.amazonaws.com/MCD43A4.006/31/11/2017158/MCD43A4.A2017158.h31v11.006.2017171203421_B01.TIF | \n", "(+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181 +units=m +no_defs ,) | \n", "(14811180.92196028, -2342509.0947640934, 14929788.977391373, -2223901.039333) | \n", "
\n",
"\n",
"\n",
" \n",
"
\n",
"
"
],
"text/plain": [
" iata airport city state country \\\n",
"0 ORD Chicago O'Hare International Chicago IL USA \n",
"1 ATL William B Hartsfield-Atlanta Intl Atlanta GA USA \n",
"2 DFW Dallas-Fort Worth International Dallas-Fort Worth TX USA \n",
"3 PHX Phoenix Sky Harbor International Phoenix AZ USA \n",
"4 DEN Denver Intl Denver CO USA \n",
"5 IAH George Bush Intercontinental Houston TX USA \n",
"6 SFO San Francisco International San Francisco CA USA \n",
"7 LAX Los Angeles International Los Angeles CA USA \n",
"8 MCO Orlando International Orlando FL USA \n",
"9 CLT Charlotte/Douglas International Charlotte NC USA \n",
"\n",
" lat long cnt \n",
"0 41.979595 -87.904464 25129 \n",
"1 33.640444 -84.426944 21925 \n",
"2 32.895951 -97.037200 20662 \n",
"3 33.434167 -112.008056 17290 \n",
"4 39.858408 -104.667002 13781 \n",
"5 29.980472 -95.339722 13223 \n",
"6 37.619002 -122.374843 12016 \n",
"7 33.942536 -118.408074 11797 \n",
"8 28.428889 -81.316028 10536 \n",
"9 35.214011 -80.943126 10490 "
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"import pandas\n",
"pandas.read_csv('https://raw.githubusercontent.com/plotly/datasets/master/2011_february_us_airport_traffic.csv').head(10)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.7.3"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
| \n", " | iata | \n", "airport | \n", "city | \n", "state | \n", "country | \n", "lat | \n", "long | \n", "cnt | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "ORD | \n", "Chicago O'Hare International | \n", "Chicago | \n", "IL | \n", "USA | \n", "41.979595 | \n", "-87.904464 | \n", "25129 | \n", "
| 1 | \n", "ATL | \n", "William B Hartsfield-Atlanta Intl | \n", "Atlanta | \n", "GA | \n", "USA | \n", "33.640444 | \n", "-84.426944 | \n", "21925 | \n", "
| 2 | \n", "DFW | \n", "Dallas-Fort Worth International | \n", "Dallas-Fort Worth | \n", "TX | \n", "USA | \n", "32.895951 | \n", "-97.037200 | \n", "20662 | \n", "
| 3 | \n", "PHX | \n", "Phoenix Sky Harbor International | \n", "Phoenix | \n", "AZ | \n", "USA | \n", "33.434167 | \n", "-112.008056 | \n", "17290 | \n", "
| 4 | \n", "DEN | \n", "Denver Intl | \n", "Denver | \n", "CO | \n", "USA | \n", "39.858408 | \n", "-104.667002 | \n", "13781 | \n", "
| 5 | \n", "IAH | \n", "George Bush Intercontinental | \n", "Houston | \n", "TX | \n", "USA | \n", "29.980472 | \n", "-95.339722 | \n", "13223 | \n", "
| 6 | \n", "SFO | \n", "San Francisco International | \n", "San Francisco | \n", "CA | \n", "USA | \n", "37.619002 | \n", "-122.374843 | \n", "12016 | \n", "
| 7 | \n", "LAX | \n", "Los Angeles International | \n", "Los Angeles | \n", "CA | \n", "USA | \n", "33.942536 | \n", "-118.408074 | \n", "11797 | \n", "
| 8 | \n", "MCO | \n", "Orlando International | \n", "Orlando | \n", "FL | \n", "USA | \n", "28.428889 | \n", "-81.316028 | \n", "10536 | \n", "
| 9 | \n", "CLT | \n", "Charlotte/Douglas International | \n", "Charlotte | \n", "NC | \n", "USA | \n", "35.214011 | \n", "-80.943126 | \n", "10490 | \n", "