Python
Safely store and use as many your login – password credential information for access of different data bases or systems in your python kernel environment without revealing the credentials in python script Use-case: It is a security consideration to avoid… Read More »How to use keyring in python code: safe storage of credentials in everyday coding
Particular useful for non-technical professionals or beginners. What are different types of marges for data tables and how we can apply them on any data tables or sheets, for example on excel or google sheets files Use-case: A tutorial for… Read More »Step-by-step Data Table Merging or Cross Referencing Tutorial for Beginners – covering all types of merges
Upload files in web scraping with two ways in an error-free manner using selenium, pyAutoGui packages in Python & Chrome-Driver Use-case: A python tutorial with example on how to automate uploading files in web scraping projects using two methods. It… Read More »Tutorial on Automated Uploading Files – Web Scraping with Selenium in Python
– Public data using a python API Use-case: In this tutorial, we show how to Download the meta data available for all the publicly available datasets or data tables from Statistics Canada in python Download any data table from Statistics… Read More »Downloading meta-data and data from Statistics Canada
Example for applying plotly (plotly.px) in Python to create interactive bar charts Use-case: A Python tutorial for data visualization beginners guide on how to create interactive chart in Python. In this blog, we use a bar chart as an example… Read More »Interactive charts in Python
Getting structured address components (Street name, street number, street direction, city, state/province, etc.) from unstructured text examples of using ez_address_parser and usaddress packages Use-case: Let’s say we want to extract consistent and structured address information from raw text or from… Read More »Parsing Address strings in Python: structure address text data in python
– cross reference and apply shapefile polygons on coordinates in data – Python/GIS | Geopandas & shapley Use-case: Applying reverse-geocoding free of charge using an appropriate shapefile (including polygons data) in Python. Let’s say you have some geographical coordinates in… Read More »Reverse Geocoding: Find city names from latitude and longitude coordinates
Use-case: I want to automate the scraping and storing results from google search engine based on a set of keywords and queries using Python. One possible use-case for this scraping could be a need for finding news or contextual information… Read More »Scraping google search results based on query keywords in Python
This tutorial shows how to visualize an interactive map in python. We visualize a map of polyline or a route or road map in python. We use an example of transit or bus route map to visualize in this blog.… Read More »How-to: Geographical visualization of a route or road path such as bus transits
– simple code win in Python GIS tutorial Use-case: Sort a tabular data based on one or multiple columns using a simple and accessible python method. Specially useful for less technical background who may deal with a spreadsheet in excel… Read More »Sorting spreadsheets based on one or multiple columns – quick solution for slow loading sheets in excel or google sheets