Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Tarandeep Singh
5 articles
How to Automate an Excel Sheet in Python?
Data storage, analysis, and presentation are frequently done using Excel. The popular programming language Python, on the other hand, is renowned for its ease of use, adaptability, and versatility. For use with Excel spreadsheets and for various task automation, Python offers a number of libraries. We can easily make use of Python for automating Excel spreadsheets. For doing the same, we will be covering various approaches in this article: Approaches Using the openpyxl library Using the pandas library Using the xlwings library Method 1: Using the openpyxl library We can use the Python Openpyxl package for interacting with ...
Read MoreGet the day from a date in Pandas
Pandas is a popular Python library that is used for data analysis and manipulation. Dealing with date and time is a common task while working with data analysis and manipulation in Python Pandas. Getting the day from a given date is a real-life task that might have come across many developers. This task is made easier by a number of functions and methods offered by Pandas. Knowing how to get the day from a date can be very helpful in many cases. In this article, we'll look at several methods for determining the day of the week in Pandas. You ...
Read MoreGet the data type of column in Pandas - Python
Pandas is a popular and powerful Python library commonly used for data analysis and manipulation. It offers a number of data structures, including the Series, DataFrame, and Panel, for working with tabular and time-series data. Pandas DataFrame is a two-dimensional tabular data structure. In this article, we'll go through various methods for determining a column's data type in Pandas. There can be numerous cases where we have to find the data type of a column in Pandas DataFrame. Each column in a Pandas DataFrame can contain a different data type. Before Moving forward, let's make a sample dataframe on which ...
Read MoreGet tag name using Beautifulsoup in Python
BeautifulSoup is known as one of the most widely used Python packages for web scraping. It is one of the most fantastic tools used for parsing HTML and XML documents, making it simpler and quicker to extract data from websites. Extraction of the tag name for particular HTML and XML components is one of the most frequent tasks in web scraping. Getting the tag name of a given element is one of the most frequent tasks when working with HTML and XML documents. Python’s BeautifulSoup library can be installed using the below command: pip install beautifulsoup4 Approach ...
Read MoreGet specific row from PySpark dataframe
PySpark is a powerful tool for data processing and analysis. When working with data in a PySpark DataFrame, you may sometimes need to get a specific row from the dataframe. It helps users to manipulate and access data easily in a distributed and parallel manner, making it ideal for big data applications. In this article, We will explore how to get specific rows from the PySpark dataframe using various methods in PySpark. We will cover the approaches in functional programming style using PySpark's DataFrame APIs. Before Moving forward, let's make a sample dataframe from which we have to get the ...
Read More