PinnedMainak DasinThe ScribblersReading & Writing Files with Python PandasDifferent ways in which you can input and output data with Python pandas.Jan 6, 20221Jan 6, 20221
Mainak DasinPython in Plain EnglishTransforming Postgres Table Data to JSON Using Python & SQLHow to convert Multiple Postgres Tables Data into JSON Files Using Python & SQLNov 29, 2023Nov 29, 2023
Mainak DasinPython in Plain EnglishUnderstanding the Pros and Cons of Data Warehouse and Data LakesChoose The Right Data Solution For Your Business By Understanding The Pros & Cons Of Data Warehouse and Data LakesFeb 28, 2023Feb 28, 2023
Mainak DasData Engineering 101: Understanding the Differences Between OLAP and OLTPA Comprehensive Guide to OLAP and OLTP SystemsFeb 25, 2023Feb 25, 2023
Mainak DasinPython in Plain EnglishUnderstanding Slowly Changing Dimensions (SCD) in Data WarehousingExploring Different SCD Types, Their Advantages, Disadvantages, and Applications.Feb 24, 2023Feb 24, 2023
Mainak DasinPython in Plain EnglishAdvanced Python Topics: Metaclasses vs InheritanceUnderstanding the differences between Metaclasses and Inheritance in PythonFeb 23, 2023Feb 23, 2023
Mainak DasinPython in Plain EnglishA Comprehensive Guide to File Formats in Data EngineeringUnderstanding the Pros and Cons of using CSV, JSON, Parquet, Avro, and ORC file format in Data Engineering.Feb 20, 20233Feb 20, 20233
Mainak DasinPython in Plain EnglishData Science Buzzwords Series: Statistics: Part 1These are summaries of some buzzwords I often come across while studying Data Science in general.Feb 18, 2023Feb 18, 2023
Mainak DasinPython in Plain EnglishAdvanced Python Topics: Iterators, Generators & DecoratorsUnderstanding the concepts of Iterators, Generators & Decorators in Python.Feb 13, 2023Feb 13, 2023
Mainak DasinPython in Plain EnglishObject Oriented Programming (OOP) in Python — Abstraction & EncapsulationAbstraction and encapsulation are two crucial concepts of Object Oriented Programming(OOP) in the field of computer science that are used…Feb 12, 20231Feb 12, 20231