Amany AbdelhaliminAnalytics VidhyaEasy Data Analysis and Manipulation Using Pandas LibraryIn this post, I will show you how to use Pandas library to analyze and manipulate your data.Jan 15, 2021Jan 15, 2021
Amany AbdelhaliminThe StartupA Clear Summary and Examples of Dates, Times, and Timestamp Functions With PostgreSQLIf you did not enjoy handling dates and time before, I would recommend you going through my post and hopefully you will change your mind…Jan 15, 2021Jan 15, 2021
Amany AbdelhaliminAnalytics VidhyaInteresting 5 Functions and 5 Triggers With PostgreSQLIn this post, I will take you through the process of creating triggers and functions. I prepeared 5 examples of different interesting…Dec 4, 20203Dec 4, 20203
Amany AbdelhaliminAnalytics VidhyaLearn Data Analysis with 30 SQL QueriesLet’s do some data analysis with SQL. Check my previous post where I answered 30 interesting questions using powerful SQL queries. In…Nov 27, 20201Nov 27, 20201
Amany AbdelhaliminAnalytics VidhyaLets Do Some Data Analysis with SQL-PostgreSQLIn this post, I will teach you how to do data analysis by writing some interesting SQL queries using the following tables, which are part…Nov 19, 2020Nov 19, 2020
Amany AbdelhalimAppending/Overwriting with Different Schema to Delta Lake Vs Parquet.Delta Lake has unique characteristics and one of them is Schema Enforcement. Attempting to add data to a Delta file that has different…Oct 24, 20203Oct 24, 20203
Amany AbdelhaliminThe StartupDo Delta and Parquet Files Refresh Automatically When Appending New Data to Them?Delta Lake is an open source, intermediary storage level between Apache Spark and the storage layer (HDFS, S3,...,etc) and it brings…Sep 28, 20201Sep 28, 20201
Amany AbdelhaliminThe StartupPreprocessing Criteo Dataset for Prediction of Click Through Rate on AdsIn this post, I will be taking you through the steps that I performed to preprocess the Criteo Data set.Sep 17, 2020Sep 17, 2020
Amany AbdelhaliminThe StartupML Model Prediction on Streaming Data Using KafkaIn one of my previous posts, I took you through the steps that I performed to preprocess Criteo dataset used for prediction of the click…Sep 17, 2020Sep 17, 2020
Amany AbdelhalimData Lake StoryIn this article, I will explain the concepts of Data Lakes in a story telling fashion. The story itself is fiction but it represents the…Aug 16, 2020Aug 16, 2020