Microsoft Excel is arguably the most popular business software on the planet, with almost every single company making use of it in one way or another. Proficiency in Excel is a must-have skill in many jobs. Here is the rub. Managing data in Excel manually is often quite repetitive and tedious. Wouldn’t it be great if you could still leverage the power of Microsoft Excel while reducing the repetition?…

Selenium is a tool to automate controlling any type of web browser that works with languages like Python, Java, C#, Ruby, and others. We’ll be looking at how to use Selenium with Python in this tutorial. By using Python with Selenium, you can launch the browser of your choice, fetch any webpage, programmatically click links, fill out web forms, and use other browser functions like back, forward, and reload.…

This Python tutorial will focus on comprehensions and how to use them. The concept of comprehension in Python is that it is an easier and more readable way to create a list or other sequence. Creating a list is the most common application of comprehension, but it can also be used with a dictionary, tuple, set, or even a string. It is also possible to add logic to a comprehension with an if statement or an if else statement.…

There are many tips and tricks in Python that can make your coding a bit easier. In this tutorial, we’re going to take a look at a whole bunch of tips and tricks you might like when working with Python. Some of the topics to cover include the Python conditional operator (Ternary), merging dictionaries, underscores to help with large numbers, printing a list in a specific order, how to use context managers, finding the most common item in a list, using the enumerate function, swapping variables, using help(), using zip(), and many more.…

Matplotlib is a Python library that is used often with Jupyter Notebook. The module in matplotlib that is used is called pyplot. In this tutorial, we’ll learn a little bit about matplotlib and how to use it in Jupyter Notebook. Matplotlib.pyplot provides a MATLAB-like way of plotting. This means that pyplot has many functions to make changes to a figure. Matplotlib in combination with Jupyter Notebook is a popular way to visualize data using Python for all kinds of applications in science, technology, and education.…

There are two modes in Jupyter. These are edit mode and command mode. If the cell has a green border, that means you’re in edit mode. If the cell has a blue border, then you’re in command mode. Edit mode is for all the actions you would usually perform in the context of the cell. When you are editing and typing your code and text, this is edit mode.…

Jupyter Notebook is a Python environment to help you explore and analyze data using Python. It is an expressive platform that helps you to communicate ideas with code and graphs. Jupyter combines live code and textual explanations along with data visualizations to make documents come alive. In this tutorial, we’ll take a look at getting started with Jupyter Notebook. We’ll install Jupyter notebook in a virtualenv which we learned about recently.…

Web scraping is a common technique used to fetch data from the internet for different types of applications. With the almost limitless data available online, software developers have created many tools to make it possible to compile information efficiently. During the process of web scraping, a computer program sends a request to a website on the internet. An Html document is sent back as a response to the program’s request.…