Open in app

Sign In

Write

Sign In

Ezzeddin Abdullah
Ezzeddin Abdullah

322 Followers

Home

About

Published in Brainwave

·Pinned

How to Create Good Habits and Quit Bad Ones

Based on science, how I made reading a habit and 345-day streak at Duolingo — You’ve probably been asked a question before and your answer was That’s what I’m used to And that’s because there is already a habit formed, but what is a habit? And when to tell there is a habit involved? And how can you create a new habit and quit a…

Habits

8 min read

How to Create Good Habits and Quit Bad Ones
How to Create Good Habits and Quit Bad Ones
Habits

8 min read


Published in Level Up Coding

·Pinned

A Rising Library Beating Pandas in Performance

Comparing the performance of pypolars and pandas — pandas was initially released in 2008 written in Python, Cython, and C. Today, we’re comparing the performance of this well-known library with pypolars, a rising DataFrame library written in Rust. We compare the two while sorting and concatenating a 25Mil-record data and also when joining two CSVs. Downloading Reddit Usernames data Let’s first download…

Data Science

4 min read

A Rising Library Beating Pandas in Performance
A Rising Library Beating Pandas in Performance
Data Science

4 min read


Pinned

How to Write a Book with Python and Sphinx

Want to write a technical book or document your project? Here I’ll walk you through how you can do that with python and sphinx. You can build content of tables that can contain sections to the chapters of your book. I will show you a case study to know how…

Python

7 min read

How to Write a Book with Python and Sphinx
How to Write a Book with Python and Sphinx
Python

7 min read


Published in Analytics Vidhya

·Pinned

How to Get Trending Tweets in any Country with Python and Tweepy

Trends in your hand — Social Analytics companies have been massively using twitter to get insights about whatever data they are interested in for brands, celebrities, etc. and also trending topics. In this tutorial, you’ll know how to get countries that have trends on Twitter and also get insights about what topics are trending the…

Data Science

5 min read

How to Get Trending Tweets in any Country with Python and Tweepy
How to Get Trending Tweets in any Country with Python and Tweepy
Data Science

5 min read


Published in Brainwave

·Jan 19

SQL Functions and Techniques Every Data Person Should Know

Writing SQL queries that don’t utilize database features can cost developers a lot. The cost varies from spending more time writing tedious long queries or having a tech debt later on to debug the performance issue coming from the database server. PostgreSQL has features that help you select data efficiently…

Technology

8 min read

SQL Functions and Techniques Every Data Person Should Know
SQL Functions and Techniques Every Data Person Should Know
Technology

8 min read


Published in Brainwave

·Jan 5

How to Interact with Databases using SQLAlchemy with PostgreSQL

Databases can be accessed in Python through a database connector where you can write SQL queries as you do in a SQL client. Writing these queries can be complex and error-prone–especially when you are using a language like Python where all data you deal with are objects or relations between…

Technology

10 min read

How to Interact with Databases using SQLAlchemy with PostgreSQL
How to Interact with Databases using SQLAlchemy with PostgreSQL
Technology

10 min read


Published in Brainwave

·Dec 31, 2022

Why & How to use Window Functions to Aggregate Data in PostgreSQL

A window function is a feature developed in PostgreSQL — available since version 8.4 — to analyze data beyond the current row (hence the term “window”). These windows can aggregate information to each row of your output. Apart from aggregate functions and groupings, window functions provide another way to perform…

Technology

9 min read

Why & How to use Window Functions to Aggregate Data in PostgreSQL
Why & How to use Window Functions to Aggregate Data in PostgreSQL
Technology

9 min read


Published in Brainwave

·Dec 22, 2022

Monitoring PostgreSQL Performance with pg_stat_statements Extension

Monitoring PostgreSQL performance is essential if you want to have a highly-performant app. To do so, there are tools to leverage to be able to detect slow-running queries and take action. In this tutorial, we will dig deep into the pg_stat_statements extension. You will not only detect slow-running queries, but…

Dev Ops

8 min read

Monitoring PostgreSQL Performance with pg_stat_statements Extension
Monitoring PostgreSQL Performance with pg_stat_statements Extension
Dev Ops

8 min read


Published in Brainwave

·Dec 7, 2022

How Database Design Matters in PostgreSQL Performance

Practical tips to follow when you design your database for boosting performance — PostgreSQL performance starts right away at the data modeling phase. When you start designing your tables, PostgreSQL optimizer adapts to your changes and hence boost your database performance or hurt it. In this PostgreSQL tutorial, you will learn how database design matters in PostgreSQL performance tuning. You'll gain insights about…

Dev Ops

8 min read

How Database Design Matters in PostgreSQL Performance
How Database Design Matters in PostgreSQL Performance
Dev Ops

8 min read


Published in Brainwave

·Nov 16, 2022

A Guide on Python String replace() Method

Replacing characters in strings using Python can be done with multiple ways. In this quick tutorial, you'll learn how to use the replace method to manipulate strings. You'll learn through examples how to replace a character in a string, how to replace multiple characters in a string, and how to…

Technology

2 min read

A Guide on Python String replace() Method
A Guide on Python String replace() Method
Technology

2 min read

Ezzeddin Abdullah

Ezzeddin Abdullah

322 Followers

I mainly write about habits, Python, SQL, & Data. Get my free Cleaner Python ebook: https://ezzeddin.gumroad.com/l/cleaner-python

Following
  • Dr Mehmet Yildiz

    Dr Mehmet Yildiz

  • Tim Denning

    Tim Denning

  • Areeba Merriam

    Areeba Merriam

  • Giorgos Myrianthous

    Giorgos Myrianthous

  • Neeramitra Reddy

    Neeramitra Reddy

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Text to speech