Managing virtual environment in Anaconda

A virtual environment is an isolated copy of your environment that maintains its own version of the language, packages, and versions. It can help in avoiding version conflicts and dependency issues among projects. Anaconda provides a convenient way to manage packages and different environments needed for data science projects. It also helps in creating and … Read more Managing virtual environment in Anaconda

Selection in Pandas – iloc, loc Explained

Data exploration and manipulation is the basic building block for data science. We cannot do this without making selections in our table. At first, it was very confusing and took some time for me to get hang of making selections in Pandas DataFrame. Pandas provided different options for selecting rows and columns in a DataFrame … Read more Selection in Pandas – iloc, loc Explained

12 examples on Python Regular Expression

  In the last post (Beginner’s Guide to Python Regular Expression), we learnt about python regular expression.  If you don’t know the basic syntax and structure of it, then it will be better to read the mentioned post. If you know, then let’s practice some of the concept mentioned. We will work out some examples … Read more 12 examples on Python Regular Expression

Beginners’ Guide to Python Regular Expression

  Python regular expression is one of the most difficult concepts for the beginners to wrap their heads around. It needs some practice to master it and can be very confusing in the beginning. But once mastered, it is a very handy toolto have and can be used in a lot of different cases: – … Read more Beginners’ Guide to Python Regular Expression

Introduction to Python Dictionary

Python has a unique data type known as dictionary or python dictionary. It provides a very easy and flexible way to store and organize values. In essence, it is like a list as it can also store multiple values. There are two major difference between list and python dictionary and they are:- Indexes – List … Read more Introduction to Python Dictionary

Introduction to SQLite using Python

Introductory tutorial of SQLite using Python.SQLite is a zero-configuration SQL database engine and can also be considered as a file-based database. It is a very small and lightweight database which has no external dependencies. It can be a very useful tool for data analysis process as you can create RDBMS structure from within your code and then run queries on the whole table in an efficient manner,  without any need of server installation or configuration. We will explore SQLite basics in this tutorial. Python has an in-built sqlite3 module, which can be used to work with SQLite database.

SQL Query in Python – SELECT

I had been using SQL extensively to work on the tabular data format. So, when I started learning python, it was essential for me to write SQL query in python. Knowing this, really helped me in using python extensively for data exploration process. I hope that people who are learning python for data analysis and … Read more SQL Query in Python – SELECT

Using Pandas to change Python display options

Pandas provides a very easy way to customize your Python display options. Even though it is not essential for data analysis, but it makes data exploration easy and gives you some more flexibility. Most useful available parameters are:- display.max_rows :- This deals with the number of rows that can be displayed. If no. of rows exceeds … Read more Using Pandas to change Python display options