PinnedMember-onlyMy Top ArticlesHere are some related posts you can explore if you’re interested in Linear Regression and Causal Inference. Causal Inference: Econometric Models vs. A/B Testing Linear Regression vs. Logistic Regression: OLS, Maximum Likelihood Estimation, Gradient Descent Linear Regression with OLS: Unbiased, Consistent, BLUE, Best (Efficient) Estimator Causal Inference with Linear Regression…Linear Regression1 min read
Published in Towards Data Science·PinnedMember-onlyWork with SQL in Python Using SQLAlchemy and PandasExtract SQL tables, insert, update, and delete rows in SQL databases through SQLAlchemy — In a data science project, we often need to interact with Relational databases, such as, extracting tables, inserting, updating, and deleting rows in SQL tables. To accomplish these tasks, Python has one such library, called SQLAlchemy. It supports popular SQL databases, such as PostgreSQL, MySQL, SQLite, Oracle, Microsoft SQL Server…Sqlalchemy5 min read
Published in Towards Data Science·PinnedMember-onlyScrape Data from PDF Files Using Python and PDFQueryExtract Data from PDF Files Effectively — Background In the previous article, I talked about how to use tabula-py and Pandas in Python to scrape data from both structured and unstructured data from PDF files. In this article, I’m going to introduce an alternative way to scrape data from PDF files: PDFQuery. Required Libraries PDFQuery: to scrape text from PDF…Python5 min read
Published in Towards Data Science·PinnedMember-onlyLinear Regression vs. Logistic Regression: OLS, Maximum Likelihood Estimation, Gradient DescentThe differences in terms of cost functions, Ordinary Least Squares (OLS), Gradient Descent (GD), and Maximum Likelihood Estimation (MLE). — In this article, I’ll cover a roadmap for statistical model development. Specifically, we’ll talk about how the development of linear regression differs from logistic regression. We’ll also discuss why some methods work in one model, but not in another model. The following is an overview of this roadmap.Linear Regression14 min read
Published in Towards Data Science·PinnedMember-onlyCausal Inference: Econometric Models vs. A/B TestingObservational Study, Experimental Study, Regression Model, Instrumental Variable, Difference-in-difference Model, Parametric Test and Non-Parametric Test — As data science practitioners, we’ve been asked a lot that “Does X drive Y?” Y is the outcome that we care about. X could be a new feature, product or drug. For example, a website owner would like to ask if a new web page design leads to a higher…Ab Test16 min read
4 hours agoMember-onlyComprehensive SQL Cheat SheetThe most common SQL functions you must know — SQL is one of the most popular programming languages for data science. Being able to write effective queries has become an essential skill for data science professionals. In this article, we will discuss the most commonly used SQL functions. …Sql9 min read
Published in Towards Data Science·1 day agoMember-onlyCrack SQL Interview Question: Date_Part FunctionSolving SQL questions with useful procedures — In this article, we will go over a SQL question from an Amazon data science interview. Hope the procedure explained in this article would help you become more effective in writing SQL queries. SQL Question: Best Selling Item Find the best-selling item for each month (no need to separate months…Sql5 min read
Published in Towards Data Science·6 days agoMember-onlyCrack SQL Interview Question: Window Functions with Partition-BySolving SQL questions with useful procedures — In this article, we will go over a SQL question from an Amazon data science interview. Hope the procedure explained in this article would help you become more effective in writing SQL queries. SQL Question: Marketing Campaign Success You have a table of in-app purchases by user. Users that make…Sql6 min read
Published in Towards Data Science·Sep 15Member-onlyCrack SQL Interview Question: Join vs Case-When StatementSolving SQL questions with useful procedures — In this article, we will go over a SQL question from a Facebook data science interview. Hope the procedure explained in this article would help you become more effective in writing SQL queries. SQL Question: Users By Average Session Time Calculate each user's average session time. A session is defined…Sql6 min read
Published in Python in Plain English·Sep 13Member-onlyComprehensive Python Pandas Cheat SheetThe most common Pandas functions for data wrangling — Undoubtedly Pandas is one of the most popular Python libraries for data science. Its versatility and functionalities make it a powerful tool for data wrangling and exploration. Getting familiar with Pandas has become an essential skill for data science professionals. In this article, we…Pandas10 min read
