This article shows you how to export a Database Table to a CSV file using MySQL. âšī¸ SQL, an acronym for Structured Query Language, is the language of the Database! This standardized language is used to manage databases, tables and the data they hold. A must-have in the coding world. This language allows coders to … Read more
Problem Formulation and Solution Overview đĄ This article will show you how to delete a line from a file in Python. To make it more interesting, we have the following running scenario: Rivers Clothing has a flat text file, rivers_emps.txt containing employee data. What happens if an employee leaves? They would like you to write … Read more
The article begins by formulating a problem regarding how to extract emails from any website using Python, gives you an overview of solutions, and then goes into great detail about each solution for beginners. At the end of this article, you will know the results of comparing methods of extracting emails from a website. Continue … Read more
Given an image as a .png or .jpeg file. How to convert it to a CSV file in Python? Example image: Convert the image to a CSV using the following steps: Read the image into a PIL.Image object. Convert the PIL.Image object to a 3D NumPy array with the dimensions rows, columns, and RGB values. … Read more
Problem đŦ Challenge: How to convert a Parquet file ‘my_file.parquet’ to a CSV file ‘my_file.csv’ in Python? In case you don’t know what a Parquet file is, here’s the definition: đĄ Info: Apache Parquet is an open-source, column-oriented data file format designed for efficient data storage and retrieval using data compression and encoding schemes to … Read more
Problem Given the following Markdown table stored in ‘my_file.md’: đ Python Challenge: How to convert the Markdown table to a CSV file ‘my_file.csv’? Solution To convert a Markdown table .md file to a CSV file in Python, first read the Markdown table file by using the f.readlines() method on the opened file object f, by … Read more
A not-so-fictious problem: Say, you’ve created a web application that runs on a dedicated Linux server in the cloud. Thousands of users visit your web app and suddenly … it crashes. Your users start complaining, and you lose revenue. More importantly, you bleed credibility by the hour. Your server is down, so what do you … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to print a string and an integer together in Python. To make it more fun, we have the following running scenario: The Finxter Academy has decided to send its users an encouraging message using their First Name (a String) and Problems Solved (an Integer). … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to ignore (upper/lower/title) case characters when dealing with Strings in Python. The main reason for ignoring the case of a String is to perform accurate String comparisons or to return accurate search results. For example, the following three (3) Strings are not identical. If … Read more
Given an HTML table (code) in a file or at a given URL. First, load all HTML tables into the Python script by calling Pandas’ pd.read_html() passing the URL of the HTML document. The result is a list of DataFrames, one per HTML table in the document. Second, convert any specific DataFrame to a CSV … Read more
What is KML? âšī¸ Definition: The Keyhole Markup Language (KML) is a file format for displaying geographic data in Google Earth or other so-called “Earth Browsers”. Similarly to XML, KML uses a tag-based structure with nested elements and attributes. How to Convert KML to CSV in Python? You can convert a .kml to a .csv … Read more
What is GeoJSON? đĄ GeoJSON is an RFC standardized data format to encode geographic data structures such as Point, LineString, Polygon, MultiPoint, MultiLineString, and MultiPolygon. GeoJSON is based on the JavaScript Object Notation (JSON). Example GeoJSON to CSV Say, you have the following GeoJSON snippet: You want to convert it to the following CSV format: … Read more