René's URL Explorer Experiment


Title: GitHub - deniskram/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 - deniskram/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 - deniskram/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. - deniskram/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. - deniskram/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. - deniskram/python-data-cheatsheet

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

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:f927ded4-fba6-47ca-729a-68baa0374f24
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id99B8:1F1FAC:891C0E:AFE2DB:697E599D
html-safe-nonce022c6fbe785f61f0fc23a123a72981fbf9c459fdadb99f98026f326eff30de70
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5OUI4OjFGMUZBQzo4OTFDMEU6QUZFMkRCOjY5N0U1OTlEIiwidmlzaXRvcl9pZCI6IjU1MDMxNDExOTg3MDI3Mjk2MjkiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmacf020955f11657db1168364e7ce788808b60d15dd0e4ca5a4d885adc2127d8c0a
hovercard-subject-tagrepository:532255527
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/deniskram/python-data-cheatsheet
twitter:imagehttps://opengraph.githubassets.com/dd3aebe7113a10311a21a1413d1d8b1563393934bf5db04d93a7dac6f8534cf0/deniskram/python-data-cheatsheet
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/dd3aebe7113a10311a21a1413d1d8b1563393934bf5db04d93a7dac6f8534cf0/deniskram/python-data-cheatsheet
og:image:altThings in Python, Pandas, GeoPandas and Jupyter that I've had to look up or weren't obvious in the documentation. - deniskram/python-data-cheatsheet
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None60279d4097367e16897439d16d6bbe4180663db828c666eeed2656988ffe59f6
turbo-cache-controlno-preview
go-importgithub.com/deniskram/python-data-cheatsheet git https://github.com/deniskram/python-data-cheatsheet.git
octolytics-dimension-user_id80754514
octolytics-dimension-user_logindeniskram
octolytics-dimension-repository_id532255527
octolytics-dimension-repository_nwodeniskram/python-data-cheatsheet
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forktrue
octolytics-dimension-repository_parent_id195449271
octolytics-dimension-repository_parent_nwoghing/python-data-cheatsheet
octolytics-dimension-repository_network_root_id195449271
octolytics-dimension-repository_network_root_nwoghing/python-data-cheatsheet
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release7c85641c598ad130c74f7bcc27f58575cac69551
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/deniskram/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%2Fdeniskram%2Fpython-data-cheatsheet
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://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%2Fdeniskram%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=deniskram%2Fpython-data-cheatsheet
Reloadhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
Reloadhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
Reloadhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
deniskram https://patch-diff.githubusercontent.com/deniskram
python-data-cheatsheethttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
ghing/python-data-cheatsheethttps://patch-diff.githubusercontent.com/ghing/python-data-cheatsheet
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fdeniskram%2Fpython-data-cheatsheet
Fork 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fdeniskram%2Fpython-data-cheatsheet
Star 0 https://patch-diff.githubusercontent.com/login?return_to=%2Fdeniskram%2Fpython-data-cheatsheet
0 stars https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/stargazers
2 forks https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/forks
Branches https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/branches
Tags https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tags
Activity https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/activity
Star https://patch-diff.githubusercontent.com/login?return_to=%2Fdeniskram%2Fpython-data-cheatsheet
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fdeniskram%2Fpython-data-cheatsheet
Code https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
Pull requests 0 https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/pulls
Actions https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/actions
Projects 0 https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/projects
Security 0 https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/security
Insights https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/pulse
Code https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
Pull requests https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/pulls
Actions https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/actions
Projects https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/projects
Security https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/security
Insights https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/pulse
Brancheshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/branches
Tagshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tags
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/branches
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tags
90 Commitshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/commits/main/
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/commits/main/
data/sourcehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/data/source
data/sourcehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/data/source
notebookshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/notebooks
notebookshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/notebooks
scriptshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/scripts
scriptshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/tree/main/scripts
.gitignorehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.gitignore
.gitignorehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.gitignore
.pre-commit-config.yamlhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.pre-commit-config.yaml
.pre-commit-config.yamlhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.pre-commit-config.yaml
.startup.pyhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.startup.py
.startup.pyhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.startup.py
Pipfilehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/Pipfile
Pipfilehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/Pipfile
Pipfile.lockhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/Pipfile.lock
Pipfile.lockhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/Pipfile.lock
README.mdhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/README.md
README.mdhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/README.md
settings.pyhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/settings.py
settings.pyhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/settings.py
READMEhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#python-data-cheatsheet
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#basic-flow-control
Basic loops and related conceptshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/looping.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#loading-and-creating-data
Converting multiple columns to categorieshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/converting_multiple_columns_to_categories.ipynb
Creating DataFrames from lists and dictionarieshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/create_dataframes_from_lists_and_dictionaries.ipynb
Parsing date valueshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/parse_dates.ipynb
Querying a SQL database in a Jupyter notebookhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/sql_query_in_jupyter_notebook.ipynb
Loading a DataFrame into a temporary table of a SQL databasehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/sql_temporary_table.ipynb
Read shapefile from ziphttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/read_shapefile_from_zip.ipynb
From CSV to GeoDataFrame in two lineshttps://anitagraser.com/2019/01/23/from-csv-to-geodataframe-in-two-lines/
Download a file with a progress barhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Writing a DataFrame to an Excel workbookhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/pandas_excel.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#loading-the-results-of-a-spatialite-spatial-query
geopandas.GeoDataFrame.from_postgis()https://geopandas.org/docs/reference/api/geopandas.GeoDataFrame.from_postgis.html#geopandas.GeoDataFrame.from_postgis
Python sqlite3.Connection object has no attribute 'enable_load_extensionhttps://code.luasoftware.com/tutorials/python/python-sqlite3-connection-objecthas-no-attribute-enable-load-extension/
Loading spatialite tables into GeoPandas GeoDataFrameshttps://gist.github.com/perrygeo/868135514d2518257bbb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#geocoding-addresses
datadesk/python-censusbatchgeocoder: A simple Python wrapper for U.S. Census Geocoding Services API batch servicehttps://github.com/datadesk/python-censusbatchgeocoder
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#examining-data
Count null values in any columnhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/count_null_values_in_any_column.ipynb
Calculate percentages of a grouphttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/percentages_of_group.ipynb
Length of a DataFramehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/length_of_dataframe.ipynb
Check if column existshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/column_exists.ipynb
Show all columnshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/show_all_columns.ipynb
Format values in a DataFramehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/noteboos/format_values.ipynb
List columnshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/list_columns.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#filtering-subsetting-and-indexing-data
Find rows with null values in any columnhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/find_null_values_in_any_column.ipynb
Find all cells with zero valueshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/find_all_cells_with_zero_value.ipynb
Select all the contents of a MultiIndex levelhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/multiindex_slice.ipynb
Select a single item by indexhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/select_single_item_by_index.ipynb
Get consecutive pairs from an interablehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/consecutive_pairs_iterable.ipynb
Select a set of items by a list of index valueshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/select_multiple_items_by_index.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#filter-a-series
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#filter-a-dataframe-using-a-function
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#filtering-dataframe-based-on-whether-a-columns-value-is-in-a-list
pandas.Series.isinhttps://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/deniskram/python-data-cheatsheet#invert-a-boolean-series
Boolean indexinghttp://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/deniskram/python-data-cheatsheet#filter-a-dataframe-column-based-on-a-string-property
Vectorized string functions for Serieshttps://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#cleaning-transforming-and-manipulating-data
Combine records when information is split across rowshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/combine_record_rows.ipynb
Split a DataFrame into chunkshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/chunk_dataframe.ipynb
Add row numbers to a DataFramehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/add_row_numbers.ipynb
GeoPandas and Shapely binary predicateshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
Get the border of a polygon feature as a line featurehttps://patch-diff.githubusercontent.com/deniskram/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 polygonhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#change-types-of-columns
This StackOverflow answerhttps://stackoverflow.com/a/28648923/386210
Overview of Pandas Data Typeshttps://pbpython.com/pandas_dtypes.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#find-and-replace-across-an-entire-dataframe
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#add-a-rank-column-to-a-dataframe
Ranking Rows Of Pandas Dataframeshttps://chrisalbon.com/python/data_wrangling/pandas_dataframe_ranking_rows/
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#summing-values-across-columns
pandas.DataFrame.sumhttps://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sum.html
pandas.DataFrame.sumhttps://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.sum.html
Pandas sum two columns, skipping NaNhttps://stackoverflow.com/questions/24386638/pandas-sum-two-columns-skipping-nan
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#flatten-multiindex-columns-into-one
python - Pandas dataframe with multiindex column - merge levels - Stack Overflowhttps://stackoverflow.com/questions/24290297/pandas-dataframe-with-multiindex-column-merge-levels
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#adding-a-quartile-column
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#add-a-column-and-return-a-new-dataframe
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#dealing-with-the-geometry-is-in-a-geographic-crs-results-form-area-are-likely-incorrect-warning-in-geopandas
areahttps://geopandas.org/docs/reference/api/geopandas.GeoSeries.area.html
Map Projection and Coordinate Reference Systemshttps://zia207.github.io/geospatial-python.io/lesson_03_pojection_coordinate_reference_system.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#parsing-addresses
usaddresshttps://github.com/datamade/usaddress
web interfacehttps://parserator.datamade.us/usaddress/
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#learning-regular-expressions
rehttps://docs.python.org/3/library/re.html
Pythexhttps://pythex.org/
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#aggregating-data
Count number of items in a grouphttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/count_items_in_group.ipynb
Count unique values within a grouphttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/count_unique_values_within_group.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#visualizing-data
Coloring a choropleth based on an explicit color value in a GeoDataFramehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/color_choropleth_explicitly.ipynb
Showing a layer of points over a layer of polygons in Altairhttps://altair-viz.github.io/altair-tutorial/notebooks/09-Geographic-plots.html#points-on-background
Quickly plotting multiple GeoPandas geometrieshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/geopandas_shapely_binary_predicates.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#jupyter-notebooks
Hide cells in HTML output of notebookhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/hide_cells_jupyter_html.ipynb
Wrap long column nameshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/wrap_column_headers.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#render-a-python-variable-in-a-markdown-cell
Python Markdownhttp://jupyter-contrib-nbextensions.readthedocs.io/en/latest/nbextensions/python-markdown/readme.html
Unofficial Jupyter Notebook Extensionshttp://jupyter-contrib-nbextensions.readthedocs.io/en/latest/index.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#showing-lower-level-logging-messages
Get Output From the logging Module in IPython Notebookhttps://stackoverflow.com/questions/18786912/get-output-from-the-logging-module-in-ipython-notebook
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#avoiding-having-to-manually-reimport-modules-when-you-change-code-in-them
autoreloadhttps://ipython.readthedocs.io/en/stable/config/extensions/autoreload.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#sharing-code-and-variables-between-notebooks
Feather fileshttps://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_feather.html
store magichttps://ipython.readthedocs.io/en/stable/config/extensions/storemagic.html
methods for importing notebooks as moduleshttps://ipython.readthedocs.io/en/stable/config/extensions/storemagic.html
Joe Germuskahttps://twitter.com/JoeGermuska
%run magichttps://ipython.readthedocs.io/en/stable/interactive/magics.html#magic-run
https://patch-diff.githubusercontent.com/deniskram/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 optionshttps://pandas.pydata.org/pandas-docs/stable/user_guide/options.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#python-environment
Using a project-level settings modulehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/project_settings_module.ipynb
Install GeoPandas on Windowshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/notebooks/install_geopandas_windows.ipynb
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#installing-python-in-a-good-way
My Python Development Environment, 2020 Editionhttps://jacobian.org/2019/nov/11/python-environment-2020/
Python Wranglerhttp://littlecolumns.com/tools/python-wrangler/
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#use-a-particular-python-version-with-pipenv
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#running-a-script-and-dropping-to-the-debugger-on-an-exception
Starting python debugger automatically on errorhttps://stackoverflow.com/a/2438834
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#create-a-kernel-for-use-with-jupyter
associatedpress/cookiecutter-python-projecthttps://github.com/associatedpress/cookiecutter-python-project/blob/master/hooks/post_gen_project.sh
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#integrating-code-formatters-and-linters-into-your-coding-workflow
Blackhttps://black.readthedocs.io/en/stable/
pylinthttps://www.pylint.org/
vimhttps://github.com/dense-analysis/ale/blob/master/supported-tools.md
pre-commithttps://pre-commit.com/
.pre-commit-config.ymlhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/blob/main/.pre-commit-config.yml
https://patch-diff.githubusercontent.com/deniskram/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/deniskram/python-data-cheatsheet#listing-the-path-to-a-virtual-environment-created-with-pipenv
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#specifying-the-python-environment-used-by-visual-studio-code
Using Python Environments in Visual Studio Codehttps://code.visualstudio.com/docs/python/environments
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#executing-a-jupyter-notebook-from-the-command-line
Executing notebooks from the command linehttps://nbconvert.readthedocs.io/en/latest/execute_api.html#executing-notebooks-from-the-command-line
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#data-sources
https://censusreporter.org/data/table/?table=B02001&geo_ids=16000US1714000,140|16000US1714000&primary_geo_id=16000US1714000https://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-uum9https://data.cityofchicago.org/Facilities-Geographic-Boundaries/Boundaries-Neighborhoods/bbvz-uum9
https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.htmlhttps://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.htmlhttps://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.htmlhttps://www.census.gov/geographies/mapping-files/time-series/geo/tiger-line-file.html
https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#installation-of-this-project-for-local-development
Jupytexthttps://github.com/mwouts/jupytext/
Readme https://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet#readme-ov-file
Please reload this pagehttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet
Activityhttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/activity
0 starshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/stargazers
0 watchinghttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/watchers
0 forkshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/forks
Report repository https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fdeniskram%2Fpython-data-cheatsheet&report=deniskram+%28user%29
Releaseshttps://patch-diff.githubusercontent.com/deniskram/python-data-cheatsheet/releases
Packages 0https://patch-diff.githubusercontent.com/users/deniskram/packages?repo_name=python-data-cheatsheet
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.