Read and Write Files via Python
This series provides examples and tutorials about reading and writing files via Python.
Python: Load / Read Multiline CSV File
CSV is a common data format used in many applications. It's also a common task for data workers to read and parse CSV and then save it into another storage such as RDBMS (Teradata, SQL Server, MySQL). In my previous article PySpark Read Multiple Lines Records from CSV I demonstrated how to ...
Read and Write XML Files with Python
XML is a commonly used data exchange format in many applications and systems though JSON became more popular nowadays. Compared with JSON, XML supports schema (XSD) validation and can be easily transformed other formats using XSLT. XHTML is also a strict version of HTML that is XML based and used ...
Create and Read Pickle Files in Python
Pickle files are commonly used Python data related projects. This article shows how to create and load pickle files using Pandas. import pandas as pd import numpy as np file_name="data/test.pkl" data = np.random.randn(1000, 2) # pd.set_option('display.max_rows', None) df = ...
Read and parse JSON in Python
JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON.