Blogs - Page 51 Of 113

Get the items of a series not present in another series using Pandas

In this python pandas program, we will get the items of a series not present in another series using pandas library.

Steps to solve the program

Import pandas library as pd.
Create two series using pd.Series().
Get the items of a series not present in another series using df1[~df1.isin(df2)].
Print the output.

				
					import pandas as pd 
df1 = pd.Series([4,7,3,10])
df2 = pd.Series([9,4,3])
print("First series: \n",df1)
print("Second series: \n",df2)
result = df1[~df1.isin(df2)]
print(result)

Output :

				
					First series: 
 0     4
1     7
2     3
3    10
dtype: int64
Second series: 
 0    9
1    4
2    3
dtype: int64
1     7
3    10
dtype: int64

find the standard deviation of the given Series

calculate the maximum value from a series

Program to find the standard deviation of the given series

In this python pandas program, we will find the standard deviation of the given series using pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Find the standard deviation of the given series using df.std().
Print the output.

				
					import pandas as pd
df = pf.Series([2,4,6,8,10])
print(df)
print("Standard deviation of the given series: ",df.std())

Output :

				
					0     2
1     4
2     6
3     8
4    10
dtype: int64
Standard deviation of the given series:  3.1622776601683795

find the mean of the data of a given series

get the items of a series not present in another series

Program to find the mean of the data of a given series

In this python pandas program,we will find the mean of the data of a given series using pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Find the mean of the given series using df.mean().
Print the output.

				
					import pandas as pd
df = pf.Series([5,4,8,6])
print(df)
print("Mean of the given series: ",df.mean())

Output :

				
					0    5
1    4
2    8
3    6
dtype: int64
Mean of the given series:  5.75

change the order of the index of a given series

find the standard deviation of the given Series

Change the order of the index of a given series

In this python pandas program, we will change the order of the index of a given series using pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Change the order of the index of a given series using df.reindex(index=[2,3,0,1,4,5]).
It will arrange the series in the above index order.
Print the output.

				
					import pandas as pd
df = pd.Series(data = ['sqa','tools','learning','python','is','fun'],
              index = [0,1,2,3,4,5])
print("Original Data Series:")
print(df)
df = df.reindex(index = [2,3,0,1,4,5])
print("Data Series after changing the order of index:")
print(df)

Output :

				
					Original Data Series:
0         sqa
1       tools
2    learning
3      python
4          is
5         fun
dtype: object
Data Series after changing the order of index:
2    learning
3      python
0         sqa
1       tools
4          is
5         fun
dtype: object

create a subset of a given series based on value and condition

find the mean of the data of a given series

Create a subset of a given series using Pandas

In this python pandas program, we will create a subset of a given series using Pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Now create a subset of a given series using logic in this case, df[df < 40].
Print the output.

				
					import pandas as pd
df = pd.Series([10,25,69,74,33,54,21])
print(df)
print("Subset of the above Data Series:")
new = df[df < 40]
print(new)

Output :

				
					0    10
1    25
2    69
3    74
4    33
5    54
6    21
dtype: int64
Subset of the above Data Series:
0    10
1    25
4    33
6    21
dtype: int64

add some data to an existing series

change the order of the index of a given series

Program to add some data to an existing series

In this python pandas program, we will add some data to an existing series using pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Now add some data to the series using df.append(pd.Series([data])).
Print the output.

				
					import pandas as pd
df = pd.Series([54,27.9,'sqa',33.33,'tools'])
print("Original Data Series:")
print(df)
print("Data Series after adding some data:")
new = df.append(pd.Series(['python',100]))
print(new)

Output :

				
					Original Data Series:
0       54
1     27.9
2      sqa
3    33.33
4    tools
dtype: object
Data Series after adding some data:
0        54
1      27.9
2       sqa
3     33.33
4     tools
0    python
1       100
dtype: object

sort a given Series

create a subset of a given series based on value and condition

Program to sort a given Series using Pandas

In this python pandas program, we will sort a given Series using Pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Now sort the given series using pd.Series(series_name).sort_values().
Print the output.

				
					import pandas as pd
df = pd.Series([55,23,10,87])
print("Original Data Series:")
print(df)
new = pd.Series(df).sort_values()
print(new)

Output :

				
					Original Data Series:
0    55
1    23
2    10
3    87
dtype: int64
2    10
1    23
0    55
3    87
dtype: int64

convert a series of lists into one series

add some data to an existing series

Program to convert a series of lists into one series

In this python pandas program, we will convert a series of lists into one series using Pandas library.

Steps to solve the program

Import pandas library as pd.
Take a series of lists as input.
Now convert a series of lists into one series using pd.Series().
Print the output.

				
					import pandas as pd
a = [['Sqa','tool'],['Learning','python'],['Is','fun']]
result = pd.Series(a)
print(result)

Output :

				
					0           [Sqa, tool]
1    [Learning, python]
2             [Is, fun]
dtype: object

convert a given Series to an array

sort a given Series

Program to convert a given Series to an array

In this python pandas program, we will convert a given series to an array using NumPy and Pandas library.

Steps to solve the program

Import pandas library as pd.
Import NumPy library as np.
Create a series using pd.Series().
Now convert that series to an array using np.array(series_name.values.tolist())..

				
					import numpy as np
import pandas as pd
df1 = pd.Series([54,27.90,'sqa',33.33,'tools'])
print("Original Data Series:")
print(df1)
print("Series to an array")
result = np.array(df1.values.tolist())
print (result)

Output :

				
					Original Data Series:
0       54
1     27.9
2      sqa
3    33.33
4    tools
dtype: object
Series to an array
['54' '27.9' 'sqa' '33.33' 'tools']

change the data type of given a column or a Series

convert a series of lists into one series

Change the data type of given a column using Pandas

In this python pandas program, we will change the data type of given a column using pandas library.

Steps to solve the program

Import pandas library as pd.
Create a series using pd.Series().
Change the data-type of the series from object to float using pd.to_numeric(series name, errors=’coerce’).
It will convert all the non-string elements to float and if there is a string element it will show NaN instead.
Print the output

				
					import pandas as pd
df1 = pd.Series([54,27.90,'sqa',33.33,'tools'])
print("Original Data Series:")
print(df1)
print("Change the said data type to numeric:")
df2 = pd.to_numeric(df1, errors='coerce')
print(df2)

Output :

				
					Original Data Series:
0       54
1     27.9
2      sqa
3    33.33
4    tools
dtype: object
Change the said data type to numeric:
0    54.00
1    27.90
2      NaN
3    33.33
4      NaN
dtype: float64

convert a NumPy array to a Pandas series

convert a given Series to an array