Sachin Pal    The official version of Python . has been released by the Python organization, and with this, you get many major changes. One of the major changes we get is making GIL Global Interpreter Lock optional in Python . . In this article, you’ll see how you can disable GIL in Python . to make...

Sachin Pal    Redis is an in memory database that actually makes it the fastest among all the databases. What does in memory mean It means that it stores the data in temporary memory or RAM, in the form of key value pairs. This makes it perfect for serving results instantly. In this article, you’ll learn how...

Sachin Pal    If you are applying for data science roles, it is essential to have a solid understanding of key SQL topics and concepts. Data retrieval and manipulation are critical skills for both Data Scientists and Data Analysts, as they form the foundation for effective data analysis. Below are the SQL topics...

Sachin Pal    In this article, we’ll learn how to insert multiple entries or data in the database using a single SQL query in Python. Insert Multiple Entries in the Database We’ll see how we can insert multiple entries in the two different databases SQLite and MySQL. SQLite Create a Python file and write the...

Sachin Pal    In this article, we’ll learn how to connect MySQL database with Python using the PyMySQL database driver. Connect Database with Python First, we need to install a MySQL database driver called PyMySQL that will help us bridge Python and MySQL. Now, after installing this package, we can start the...

Sachin Pal    In this article, we’ll learn how to connect SQLite database with Python. Connect SQLite Database With Python The SQLite database driver comes installed with Python so we don’t need any third party library to access it. Python provides a sqlite package to handle connection and interaction with...

Sachin Pal    Pandas provide numerous functions and methods to clean and preprocess the dataset to make it production ready. In this article, we’ll see the methods provided by pandas to handle missing values in a dataset. df.fillna The DataFrame.fillna is used to fill in the missing values with the desired...

Sachin Pal    The DataFrame.ffill forward fill propagates missing or NaN values using the previous valid value in a column or row, while DataFrame.bfill backward fill propagates them using the next valid value. Let’s see how and when to use them. DataFrame.ffill The DataFrame.ffill method fills the...

Sachin Pal    GIL or Global Interpreter Lock can be disabled in Python version . . This is currently experimental. What is GIL It is a mechanism used by the CPython interpreter to ensure that only one thread executes the Python bytecode at a time. An Experimental Feature Python . brings major new features...

Sachin Pal    Pandas supports Copy on Write, an optimization technique that helps improve memory use, particularly when working with large datasets. Starting from version . of Pandas, the Copy on Write CoW has taken effect but has not been fully implemented. Most of the optimizations that are possible...

Sachin Pal    Both functions have a common objective: to execute Python code from the string input or code object. Even though they both have the same objective, exec and eval are not the same. Return Values The exec function doesn’t return any value whereas the eval function returns a value computed...

Sachin Pal    What is template inheritance A web application has a minimum of four to five pages. These pages contain common components like header, footer, background, etc. So, these components collectively put into a template for reusability. Other pages of the application inherit these templates, hence the...