Pandas Exercises and Programs

Pandas is an open-source Python Library that is made mainly for working with relational or labelled data both easily and intuitively. This Python library is built on top of the NumPy library, providing various operations and data structures for manipulating numerical data and time series. Pandas is fast and it has high performance & productivity for users.

👁 Pandas-Practice-Exercises pandas-questions-solutions

This Pandas Exercise is designed for beginners and experienced professionals. In this article, you will learn about all the important Pandas concepts, such as Pandas DataFrames, Pandas DataFrame Rows, Pandas DataFrame Columns and more. These concepts are essential for any budding Data Analyst or Data Scientist.
 

Pandas DataFrame - Practice Exercises

• Make a Pandas DataFrame with a two-dimensional list | Python 
• Python | Creating DataFrame from dict of narray/lists 
• Python | Creating DataFrame from dict of narray/lists 
• Creating Pandas dataframe using list of lists 
• Creating a Pandas dataframe using list of tuples 
• Create a Pandas DataFrame from List of Dicts 
• Python | Convert list of nested dictionary into Pandas dataframe 
• Replace values in Pandas dataframe using regex 
• Creating a dataframe from Pandas series 
• Construct a DataFrame in Pandas using string data 
• Clean the string data in the given Pandas Dataframe 
• Reindexing in Pandas DataFrame 
• Mapping external values to dataframe values in Pandas 
• Reshape a pandas DataFrame using stack, unstack and melt method 
• Reset Index in Pandas Dataframe 
• Python | Change column names and row indexes in Pandas DataFrame 

Pandas Dataframe Rows - Practice Exercise 

• How to iterate over rows in Pandas Dataframe 
• Different ways to iterate over rows in Pandas Dataframe 
• Selecting rows in pandas DataFrame based on conditions 
• Select any row from a Dataframe using iloc[] and iat[] in Pandas 
• Limited rows selection with given column in Pandas | Python 
• Drop rows from the dataframe based on certain condition applied on a column 
• Insert row at given position in Pandas Dataframe 
• Create a list from rows in Pandas dataframe 
• Create a list from rows in Pandas DataFrame | Set 2 
• Ranking Rows of Pandas DataFrame 
• Sorting rows in pandas DataFrame 
• Select row with maximum and minimum value in Pandas dataframe 
• Get all rows in a Pandas DataFrame containing given substring 
• Convert a column to row name/index in Pandas 
• How to randomly select rows from Pandas DataFrame 

Pandas Dataframe Columns - Practice Exercise

• Create a pandas column using for loop 
• How to get column names in Pandas dataframe 
• How to rename columns in Pandas DataFrame 
• Collapse multiple Columns in Pandas 
• Get unique values from a column in Pandas DataFrame 
• Conditional operation on Pandas DataFrame columns 
• Return the Index label if some condition is satisfied over a column in Pandas Dataframe 
• Using dictionary to remap values in Pandas DataFrame columns 
• Formatting integer column of Dataframe in Pandas 
• Create a new column in Pandas DataFrame based on the existing columns 
• Python | Creating a Pandas dataframe column based on a given condition 
• Split a column in Pandas dataframe and get part of it 
• Getting Unique values from a column in Pandas dataframe 
• Split a String into columns using regex in pandas DataFrame 
• Getting frequency counts of a columns in Pandas DataFrame 
• Change Data Type for one or more columns in Pandas Dataframe 
• Split a text column into two columns in Pandas DataFrame  
• Difference of two columns in Pandas dataframe 
• Get the index of maximum value in DataFrame column 
• Get the index of minimum value in DataFrame column 
• Get n-largest values from a particular column in Pandas DataFrame 
• Get n-smallest values from a particular column in Pandas DataFrame 
• How to drop one or multiple columns in Pandas Dataframe 
• How to lowercase column names in Pandas dataframe 
• Capitalize first letter of a column in Pandas dataframe 
• Apply uppercase to a column in Pandas dataframe  

Pandas Series - Practice Exercise

• Create a Pandas Series from array 
• Creating a Pandas Series from Dictionary 
• Creating a Pandas Series from Lists 
• Create Pandas Series using NumPy functions 
• Access the elements of a Series in Pandas  

Pandas Date and Time - Practice Exercise

• Pandas | Basic of Time Series Manipulation 
• Using Timedelta and Period to create DateTime based indexes in Pandas 
• Convert the column type from string to datetime format in Pandas dataframe