René's URL Explorer Experiment

Title: GitHub - ghing/python-data-cheatsheet: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation.

Open Graph Title: GitHub - ghing/python-data-cheatsheet: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation.

X Title: GitHub - ghing/python-data-cheatsheet: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation.

Description: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation. - ghing/python-data-cheatsheet

Open Graph Description: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation. - ghing/python-data-cheatsheet

X Description: Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation. - ghing/python-data-cheatsheet

Opengraph URL: https://github.com/ghing/python-data-cheatsheet

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:7fe702fa-7d8c-e155-a81d-0661cb24dc8f
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	C6B2:3BFB17:4792DCD:5D1DB66:6974FEB0
html-safe-nonce	c41e772bde8cb5097902cbdb507f01e1f7c349ec34e0a7d88ecb77a60a725f26
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNkIyOjNCRkIxNzo0NzkyRENEOjVEMURCNjY6Njk3NEZFQjAiLCJ2aXNpdG9yX2lkIjoiOTAwODc3NjUwMTY0NTM0NDQzMiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac	bad2123ae865326f3d7f6afc40d005cf56806ded406144c13fdfcbd4f1bbf7d5
hovercard-subject-tag	repository:195449271
github-keyboard-shortcuts	repository,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	//
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/ghing/python-data-cheatsheet
twitter:image	https://opengraph.githubassets.com/c44471fb709e4132635d2f209933fc3bbef4d8108bc2057a9cd2c0bd9701d0f5/ghing/python-data-cheatsheet
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/c44471fb709e4132635d2f209933fc3bbef4d8108bc2057a9cd2c0bd9701d0f5/ghing/python-data-cheatsheet
og:image:alt	Things in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation. - ghing/python-data-cheatsheet
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	4a4bf5f4e28041a9d2e5c107d7d20b78b4294ba261cab243b28167c16a623a1f
turbo-cache-control	no-preview
go-import	github.com/ghing/python-data-cheatsheet git https://github.com/ghing/python-data-cheatsheet.git
octolytics-dimension-user_id	110420
octolytics-dimension-user_login	ghing
octolytics-dimension-repository_id	195449271
octolytics-dimension-repository_nwo	ghing/python-data-cheatsheet
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	195449271
octolytics-dimension-repository_network_root_nwo	ghing/python-data-cheatsheet
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	488b30e96dfd057fbbe44c6665ccbc030b729dde
ui-target	canary-1
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#start-of-content
	https://patch-diff.githubusercontent.com/
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fghing%2Fpython-data-cheatsheet
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub SparkBuild and deploy intelligent apps	https://github.com/features/spark
GitHub ModelsManage and compare prompts	https://github.com/features/models
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fghing%2Fpython-data-cheatsheet
Sign up	https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=ghing%2Fpython-data-cheatsheet
Reload	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Reload	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Reload	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
ghing	https://patch-diff.githubusercontent.com/ghing
python-data-cheatsheet	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2Fghing%2Fpython-data-cheatsheet
Fork 2	https://patch-diff.githubusercontent.com/login?return_to=%2Fghing%2Fpython-data-cheatsheet
Star 15	https://patch-diff.githubusercontent.com/login?return_to=%2Fghing%2Fpython-data-cheatsheet
15 stars	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/stargazers
2 forks	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/forks
Branches	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/branches
Tags	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tags
Activity	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/activity
Star	https://patch-diff.githubusercontent.com/login?return_to=%2Fghing%2Fpython-data-cheatsheet
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2Fghing%2Fpython-data-cheatsheet
Code	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Issues 0	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/issues
Pull requests 2	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/pulls
Actions	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/actions
Projects 0	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/projects
Security 0	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/security
Insights	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/pulse
Code	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Issues	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/issues
Pull requests	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/pulls
Actions	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/actions
Projects	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/projects
Security	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/security
Insights	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/pulse
Branches	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/branches
Tags	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tags
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/branches
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tags
94 Commits	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/commits/main/
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/commits/main/
data/source	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/data/source
data/source	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/data/source
notebooks	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/notebooks
notebooks	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/notebooks
scripts	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/scripts
scripts	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/tree/main/scripts
.gitignore	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.gitignore
.gitignore	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.gitignore
.pre-commit-config.yaml	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.pre-commit-config.yaml
.pre-commit-config.yaml	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.pre-commit-config.yaml
.startup.py	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.startup.py
.startup.py	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.startup.py
Pipfile	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/Pipfile
Pipfile	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/Pipfile
Pipfile.lock	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/Pipfile.lock
Pipfile.lock	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/Pipfile.lock
README.md	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/README.md
README.md	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/README.md
settings.py	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/settings.py
settings.py	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/settings.py
README	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#python-data-cheatsheet
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#basic-flow-control
Basic loops and related concepts	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/looping.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#loading-and-creating-data
Converting multiple columns to categories	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/converting_multiple_columns_to_categories.ipynb
Creating DataFrames from lists and dictionaries	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/create_dataframes_from_lists_and_dictionaries.ipynb
Parsing date values	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/parse_dates.ipynb
Querying a SQL database in a Jupyter notebook	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/sql_query_in_jupyter_notebook.ipynb
Loading a DataFrame into a temporary table of a SQL database	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/sql_temporary_table.ipynb
Read shapefile from zip	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/read_shapefile_from_zip.ipynb
From CSV to GeoDataFrame in two lines	https://anitagraser.com/2019/01/23/from-csv-to-geodataframe-in-two-lines/
Download a file with a progress bar	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Writing a DataFrame to an Excel workbook	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/pandas_excel.ipynb
Loading the results of a Spatialite spatial query	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/load_spatialite_query_results.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#geocoding-addresses
datadesk/python-censusbatchgeocoder: A simple Python wrapper for U.S. Census Geocoding Services API batch service	https://github.com/datadesk/python-censusbatchgeocoder
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#examining-data
Count null values in any column	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/count_null_values_in_any_column.ipynb
Calculate percentages of a group	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/percentages_of_group.ipynb
Length of a DataFrame	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/length_of_dataframe.ipynb
Check if column exists	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/column_exists.ipynb
Show all columns	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/show_all_columns.ipynb
Format values in a DataFrame	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/noteboos/format_values.ipynb
List columns	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/list_columns.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#filtering-subsetting-and-indexing-data
Find rows with null values in any column	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/find_null_values_in_any_column.ipynb
Find all cells with zero values	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/find_all_cells_with_zero_value.ipynb
Select all the contents of a MultiIndex level	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/multiindex_slice.ipynb
Select a single item by index	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/select_single_item_by_index.ipynb
Get consecutive pairs from an interable	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/consecutive_pairs_iterable.ipynb
Select a set of items by a list of index values	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/select_multiple_items_by_index.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#filter-a-series
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#filter-a-dataframe-using-a-function
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#filtering-dataframe-based-on-whether-a-columns-value-is-in-a-list
pandas.Series.isin	https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.isin.html
Use a list of values to select rows from a pandas dataframe [duplicate]	https://stackoverflow.com/a/12098586/386210
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#invert-a-boolean-series
Boolean indexing	http://pandas.pydata.org/pandas-docs/stable/indexing.html#boolean-indexing
How can I obtain the element-wise logical NOT of a pandas Series?	https://stackoverflow.com/questions/15998188/how-can-i-obtain-the-element-wise-logical-not-of-a-pandas-series
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#filter-a-dataframe-column-based-on-a-string-property
Vectorized string functions for Series	https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#cleaning-transforming-and-manipulating-data
Combine records when information is split across rows	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/combine_record_rows.ipynb
Split a DataFrame into chunks	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/chunk_dataframe.ipynb
Add row numbers to a DataFrame	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/add_row_numbers.ipynb
GeoPandas and Shapely binary predicates	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Get the border of a polygon feature as a line feature	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Break a multi-polygon in one row of a GeoDataFrame into multiple rows for each polygon	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Pivot values in rows into separate columns	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/pivot_rows_into_columns.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#change-types-of-columns
This StackOverflow answer	https://stackoverflow.com/a/28648923/386210
Overview of Pandas Data Types	https://pbpython.com/pandas_dtypes.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#find-and-replace-across-an-entire-dataframe
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#add-a-rank-column-to-a-dataframe
Ranking Rows Of Pandas Dataframes	https://chrisalbon.com/python/data_wrangling/pandas_dataframe_ranking_rows/
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#summing-values-across-columns
pandas.DataFrame.sum	https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sum.html
pandas.DataFrame.sum	https://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sum.html
Pandas sum two columns, skipping NaN	https://stackoverflow.com/questions/24386638/pandas-sum-two-columns-skipping-nan
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#flatten-multiindex-columns-into-one
python - Pandas dataframe with multiindex column - merge levels - Stack Overflow	https://stackoverflow.com/questions/24290297/pandas-dataframe-with-multiindex-column-merge-levels
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#adding-a-quartile-column
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#add-a-column-and-return-a-new-dataframe
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#dealing-with-the-geometry-is-in-a-geographic-crs-results-form-area-are-likely-incorrect-warning-in-geopandas
area	https://geopandas.org/docs/reference/api/geopandas.GeoSeries.area.html
Map Projection and Coordinate Reference Systems	https://zia207.github.io/geospatial-python.io/lesson_03_pojection_coordinate_reference_system.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#parsing-addresses
usaddress	https://github.com/datamade/usaddress
web interface	https://parserator.datamade.us/usaddress/
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#learning-regular-expressions
re	https://docs.python.org/3/library/re.html
Pythex	https://pythex.org/
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#aggregating-data
Count number of items in a group	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/count_items_in_group.ipynb
Count unique values within a group	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/count_unique_values_within_group.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#visualizing-data
Coloring a choropleth based on an explicit color value in a GeoDataFrame	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/color_choropleth_explicitly.ipynb
Showing a layer of points over a layer of polygons in Altair	https://altair-viz.github.io/altair-tutorial/notebooks/09-Geographic-plots.html#points-on-background
Quickly plotting multiple GeoPandas geometries	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#jupyter-notebooks
Hide cells in HTML output of notebook	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/hide_cells_jupyter_html.ipynb
Wrap long column names	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/wrap_column_headers.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#render-a-python-variable-in-a-markdown-cell
Python Markdown	http://jupyter-contrib-nbextensions.readthedocs.io/en/latest/nbextensions/python-markdown/readme.html
Unofficial Jupyter Notebook Extensions	http://jupyter-contrib-nbextensions.readthedocs.io/en/latest/index.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#showing-lower-level-logging-messages
Get Output From the logging Module in IPython Notebook	https://stackoverflow.com/questions/18786912/get-output-from-the-logging-module-in-ipython-notebook
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#avoiding-having-to-manually-reimport-modules-when-you-change-code-in-them
autoreload	https://ipython.readthedocs.io/en/stable/config/extensions/autoreload.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#sharing-code-and-variables-between-notebooks
Feather files	https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_feather.html
store magic	https://ipython.readthedocs.io/en/stable/config/extensions/storemagic.html
methods for importing notebooks as modules	https://ipython.readthedocs.io/en/stable/config/extensions/storemagic.html
Joe Germuska	https://twitter.com/JoeGermuska
%run magic	https://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-run
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#show-all-rows-of-a-pandas-dataframe-or-series
IPython.display.display()	https://ipython.readthedocs.io/en/stable/api/generated/IPython.display.html#IPython.display.display
pandas.option_context()	https://pandas.pydata.org/docs/reference/api/pandas.option_context.html#pandas.option_context
Pandas options	https://pandas.pydata.org/pandas-docs/stable/user_guide/options.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#python-environment
Using a project-level settings module	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/project_settings_module.ipynb
Install GeoPandas on Windows	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/notebooks/install_geopandas_windows.ipynb
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#installing-python-in-a-good-way
My Python Development Environment, 2020 Edition	https://jacobian.org/2019/nov/11/python-environment-2020/
Python Wrangler	http://littlecolumns.com/tools/python-wrangler/
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#use-a-particular-python-version-with-pipenv
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#running-a-script-and-dropping-to-the-debugger-on-an-exception
Starting python debugger automatically on error	https://stackoverflow.com/a/2438834
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#create-a-kernel-for-use-with-jupyter
associatedpress/cookiecutter-python-project	https://github.com/associatedpress/cookiecutter-python-project/blob/master/hooks/post_gen_project.sh
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#integrating-code-formatters-and-linters-into-your-coding-workflow
Black	https://black.readthedocs.io/en/stable/
pylint	https://www.pylint.org/
vim	https://github.com/dense-analysis/ale/blob/master/supported-tools.md
pre-commit	https://pre-commit.com/
.pre-commit-config.yml	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/blob/main/.pre-commit-config.yml
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#tell-pylint-to-ignore-a-rule
How to disable a particular message?	https://pylint.pycqa.org/en/latest/faq.html#how-to-disable-a-particular-message
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#listing-the-path-to-a-virtual-environment-created-with-pipenv
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#specifying-the-python-environment-used-by-visual-studio-code
Using Python Environments in Visual Studio Code	https://code.visualstudio.com/docs/python/environments
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#executing-a-jupyter-notebook-from-the-command-line
Executing notebooks from the command line	https://nbconvert.readthedocs.io/en/latest/execute_api.html#executing-notebooks-from-the-command-line
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#data-sources
https://censusreporter.org/data/table/?table=B02001&geo_ids=16000US1714000,140\|16000US1714000&primary_geo_id=16000US1714000	https://censusreporter.org/data/table/?table=B02001&geo_ids=16000US1714000,140%7C16000US1714000&primary_geo_id=16000US1714000
https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Neighborhoods/bbvz-uum9	https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Neighborhoods/bbvz-uum9
https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html	https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html
https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html	https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html
https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html	https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html
	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#installation-of-this-project-for-local-development
Jupytext	https://github.com/mwouts/jupytext/
Readme	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet#readme-ov-file
Please reload this page	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Activity	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/activity
15 stars	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/stargazers
0 watching	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/watchers
2 forks	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/forks
Report repository	https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fghing%2Fpython-data-cheatsheet&report=ghing+%28user%29
Releases	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/releases
Packages 0	https://patch-diff.githubusercontent.com/users/ghing/packages?repo_name=python-data-cheatsheet
Please reload this page	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Contributors 2	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/graphs/contributors
Please reload this page	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Jupyter Notebook 98.7%	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/search?l=jupyter-notebook
HTML 1.2%	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/search?l=html
Python 0.1%	https://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet/search?l=python
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.