Posts

Showing posts with the label Date and Time

Featured Post

14 Top Data Pipeline Key Terms Explained

Image
 Here are some key terms commonly used in data pipelines 1. Data Sources Definition: Points where data originates (e.g., databases, APIs, files, IoT devices). Examples: Relational databases (PostgreSQL, MySQL), APIs, cloud storage (S3), streaming data (Kafka), and on-premise systems. 2. Data Ingestion Definition: The process of importing or collecting raw data from various sources into a system for processing or storage. Methods: Batch ingestion, real-time/streaming ingestion. 3. Data Transformation Definition: Modifying, cleaning, or enriching data to make it usable for analysis or storage. Examples: Data cleaning (removing duplicates, fixing missing values). Data enrichment (joining with other data sources). ETL (Extract, Transform, Load). ELT (Extract, Load, Transform). 4. Data Storage Definition: Locations where data is stored after ingestion and transformation. Types: Data Lakes: Store raw, unstructured, or semi-structured data (e.g., S3, Azure Data Lake). Data Warehous...

Python DateTime Objects: Manipulating and Calculating Dates

Image
Date and Time how to get and how to use is well needed in a software project. So in Python, you can find these features. Date and Time Features in Python Date feature you need it to get Date in the coding. Here the point is the Date and how to get it, and the various formats of it. Generally, you will find three different Date and Time formats. Before going into detail, here are those formats. Date and Time formats Epoch: It is a point where the time starts and is dependent on the platform. It is taken as January 1st of the current year, 00:00:00. But for UNIX systems, it is 1st January, 1970, 00:00:00 (UTC). UTC: UTC means Coordinated Universal Time (also known as Greenwich Mean Time) and is a compromise between English and French. DST: It is Daylight Saving Time which is an adjustment of the time zone by one hour during part of the year. In other words, the clock is forward by one hour in the spring and backward by one hour in the autumn to return to standard time. 1. How to get the ...