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 …
Jupyter Lab – Shortcut and Magic Functions
This post discusses some of the shortcut keys and magic functions available in the Jupyter Lab. These provides some extra functionality and make our working easier. These magic functions also provide some IDE type functionality to the Jupyter Lab.
Scraping FIFA Men’s Ranking data using python
When the world cup started, I got curious about teams and their FIFA World Ranking. I also wanted to see how the ranks of different countries have been throughout the history. This ranking was introduced in December 1992 and a point …
Installing and Configuring Jupyter Lab on Windows as a Desktop Application
Jupyter lab is an interactive development environment and the way forward for people using Jupyter notebook. It has become one of the most preferred ways to code in data science field and academia. Notebook cell-based structure was very convenient for doing …
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 …
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 …
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 …
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 …
- Page 1 of 2
- 1
- 2