w3resource

Python Pandas Data Series: Exercises, Practice, Solution

[An editor is available at the bottom of the page to write and execute the scripts. Go to the editor]

Pandas Data Series [40 exercises with solution]

1. Write a Pandas program to create and display a one-dimensional array-like object containing an array of data using Pandas module.
Click me to see the sample solution

2. Write a Pandas program to convert a Panda module Series to Python list and it's type.
Click me to see the sample solution

3. Write a Pandas program to add, subtract, multiple and divide two Pandas Series.
Sample Series: [2, 4, 6, 8, 10], [1, 3, 5, 7, 9]
Click me to see the sample solution

4. Write a Pandas program to compare the elements of the two Pandas Series.
Sample Series: [2, 4, 6, 8, 10], [1, 3, 5, 7, 10]
Click me to see the sample solution

5. Write a Pandas program to convert a dictionary to a Pandas series.

Sample Series: 
Original dictionary:
{'a': 100, 'b': 200, 'c': 300, 'd': 400, 'e': 800}

Converted series:
a    100
b    200
c    300
d    400
e    800
dtype: int64 
Click me to see the sample solution

6. Write a Pandas program to convert a NumPy array to a Pandas series.

Sample Series: 
  NumPy array:
[10 20 30 40 50]
Converted Pandas series:
0    10
1    20
2    30
3    40
4    50
dtype: int64 
Click me to see the sample solution

7. Write a Pandas program to change the data type of given a column or a Series.

Sample Series: 
    Original Data Series:
0       100
1       200
2    python
3    300.12
4       400
dtype: object
Change the said data type to numeric:
0    100.00
1    200.00
2       NaN
3    300.12
4    400.00
dtype: float64
Click me to see the sample solution

8. Write a Pandas program to convert the first column of a DataFrame as a Series.

Original DataFrame
   col1  col2  col3
0     1     4     7
1     2     5     5
2     3     6     8
3     4     9    12
4     7     5     1
5    11     0    11

1st column as a Series:
0     1
1     2
2     3
3     4
4     7
5    11
Name: col1, dtype: int64
<class 'pandas.core.series.Series'>
Click me to see the sample solution

9. Write a Pandas program to convert a given Series to an array.

Sample Output: 
Original Data Series:
0       100
1       200
2    python
3    300.12
4       400
dtype: object
Series to an array
['100' '200' 'python' '300.12' '400']
<class 'numpy.ndarray'>
Click me to see the sample solution

10. Write a Pandas program to convert Series of lists to one Series.

Sample Output: 
Original Series of list
0    [Red, Green, White]
1           [Red, Black]
2               [Yellow]
dtype: object
One Series
0       Red
1     Green
2     White
3       Red
4     Black
5    Yellow
dtype: object
Click me to see the sample solution

11. Write a Pandas program to sort a given Series.

Sample Output:
Original Data Series:
0       100
1       200
2    python
3    300.12
4       400
dtype: object
0       100
1       200
3    300.12
4       400
2    python
dtype: object
Click me to see the sample solution

12. Write a Pandas program to add some data to an existing Series.

Sample Output: 
Original Data Series:
0       100
1       200
2    python
3    300.12
4       400
dtype: object

Data Series after adding some data:
0       100
1       200
2    python
3    300.12
4       400
5       500
6       php
dtype: object
Click me to see the sample solution

13. Write a Pandas program to create a subset of a given series based on value and condition.

Sample Output:
Original Data Series:
0      0
1      1
2      2

....

9      9
10    10
dtype: int64

Subset of the above Data Series:
0    0
1    1
2    2
3    3
4    4
5    5
dtype: int64
Click me to see the sample solution

14. Write a Pandas program to change the order of index of a given series.

Sample Output:
Original Data Series:
A    1
B    2
C    3
D    4
E    5
dtype: int64
Data Series after changing the order of index:
B    2
A    1
C    3
D    4
E    5
dtype: int64
Click me to see the sample solution

15. Write a Pandas program to create the mean and standard deviation of the data of a given Series.

Sample Output:
Original Data Series:
0     1
1     2
2     3
....
7     8
8     9
9     5
10    3
dtype: int64
Mean of the said Data Series:
4.818181818181818
Standard deviation of the said Data Series:
2.522624895547565
Click me to see the sample solution

16. Write a Pandas program to get the items of a given series not present in another given series.

Sample Output:  
Original Series:
sr1:
0    1
1    2
2    3
3    4
4    5
dtype: int64
sr2:
0     2
1     4
2     6
3     8
4    10
dtype: int64

Items of sr1 not present in sr2:
0    1
2    3
4    5
dtype: int64
Click me to see the sample solution

17. Write a Pandas program to get the items which are not common of two given series.

Sample Output: 
Original Series:
sr1: 
0    1 
1    2 
2    3 
3    4 
4    5
dtype: int64
sr2:
0     2
1     4 
2     6 
3     8
4    10 
dtype: int64 

Items of a given series not present in another given series: 
0     1 
2     3 
4     5 
5     6 
6     8
7    10 
dtype: int64
Click me to see the sample solution

18. Write a Pandas program to compute the minimum, 25th percentile, median, 75th, and maximum of a given series.

Sample Output:
Original Series:
0      3.000938
1     11.370722
2     14.612143

....

17    14.118931
18     8.247458
19     5.526727
dtype: float64

Minimum, 25th percentile, median, 75th, and maximum of a given series:
[ 3.00093811  8.09463867 10.23353705 12.21537733 14.61214321]
Click me to see the sample solution

19. Write a Pandas program to calculate the frequency counts of each unique value of a given series.

Sample Output:
Original Series:
0     1
1     7
2     1
3     6

...


37    0
38    4
39    8
dtype: object
Frequency of each unique value of the said series.
0    9
2    7
9    6
....
3    2
4    1
5    1
dtype: int64
Click me to see the sample solution

20. Write a Pandas program to display most frequent value in a given series and replace everything else as 'Other' in the series.

Sample Output:
Original Series:
0     3
1     1
2     1
3     3
...
12    2
13    3
14    3
dtype: int64
Top 2 Freq: 2    6
3    5
1    4
dtype: int64
0     Other
1     Other
2     Other
3     Other
...
11        2
12        2
13    Other
14    Other
dtype: object
Click me to see the sample solution

21. Write a Pandas program to find the positions of numbers that are multiples of 5 of a given series.
Sample Output:
Original Series:
0 1
1 9
2 8
3 6
4 9
5 7
6 1
7 1
8 1
dtype: int64
Positions of numbers that are multiples of 5:
[]
Click me to see the sample solution

22. Write a Pandas program to extract items at given positions of a given series.

Sample Output:  
Original Series:
0     2
1     3
2     9
3     0
4     2
5     3
...

19    0
20    2 
21    3
dtype: object

Extract items at given positions of the said series: 
0     2
2     9
6     8
11    0
21    3
dtype: object
Click me to see the sample solution

23. Write a Pandas program to get the positions of items of a given series in another given series.

Sample Output:  
Original Series:
0     1
1     2
2     3
3     4
4     5
5     6
6     7
7     8
8     9
9    10
dtype: int64
0     1
1     3
2     5
3     7
4    10
dtype: int64
Positions of items of series2 in series1:
[0, 2, 4, 6, 9]
Click me to see the sample solution

24. Write a Pandas program convert the first and last character of each word to upper case in each word of a given series.

Sample Output:
Original Series:
0       php
1    python
2      java
3        c#
dtype: object

First and last character of each word to upper case:
0       PhP
1    PythoN
2      JavA
3        C#
dtype: object
Click me to see the sample solution

25. Write a Pandas program to calculate the number of characters in each word in a given series.

Sample Output: 
Original Series:
0       Php
1    Python
2      Java
3        C#
dtype: object

Number of characters in each word in the said series:
0    3
1    6
2    4
3    2
dtype: int64
Click me to see the sample solution

26. Write a Pandas program to compute difference of differences between consecutive numbers of a given series.

Sample Output:
Original Series:
0     1
1     3
2     5
3     8
4    10
5    11
6    15
dtype: int64

Difference of differences between consecutive numbers of the said series:
[nan, 2.0, 2.0, 3.0, 2.0, 1.0, 4.0]
[nan, nan, 0.0, 1.0, -1.0, -1.0, 3.0]
Click me to see the sample solution

27. Write a Pandas program to convert a series of date strings to a timeseries.

Sample Output:
Original Series:
0         01 Jan 2015
1          10-02-2016
2            20180307
3          2014/05/06
4          2016-04-12
5    2019-04-06T11:20
dtype: object

Series of date strings to a timeseries:
0   2015-01-01 00:00:00
1   2016-10-02 00:00:00
2   2018-03-07 00:00:00
3   2014-05-06 00:00:00
4   2016-04-12 00:00:00
5   2019-04-06 11:20:00
dtype: datetime64[ns]
Click me to see the sample solution

28. Write a Pandas program to get the day of month, day of year, week number and day of week from a given series of date strings.

Sample Output: 
Original Series:
0         01 Jan 2015
1          10-02-2016
2            20180307
3          2014/05/06
4          2016-04-12
5    2019-04-06T11:20
dtype: object
Day of month:
[1, 2, 7, 6, 12, 6]
Day of year:
[1, 276, 66, 126, 103, 96]
Week number:
[1, 39, 10, 19, 15, 14]
Day of week:
['Thursday', 'Sunday', 'Wednesday', 'Tuesday', 'Tuesday', 'Saturday']
Click me to see the sample solution

29. Write a Pandas program to convert year-month string to dates adding a specified day of the month.

Sample Output:
Original Series:
0    Jan 2015
1    Feb 2016
2    Mar 2017
3    Apr 2018
4    May 2019
dtype: object

New dates:
0   2015-01-11
1   2016-02-11
2   2017-03-11
3   2018-04-11
4   2019-05-11
dtype: datetime64[ns]
Click me to see the sample solution

30. Write a Pandas program to filter words from a given series that contain atleast two vowels.

Sample Output: 
Original Series:
0       Red
1     Green
2    Orange
3      Pink
4    Yellow
5     White
dtype: object

Filtered words:
1     Green
2    Orange
4    Yellow
5     White
dtype: object
Click me to see the sample solution

31. Write a Pandas program to compute the Euclidean distance between two given series.
Euclidean distance
From Wikipedia,
In mathematics, the Euclidean distance or Euclidean metric is the "ordinary" straight-line distance between two points in Euclidean space. With this distance, Euclidean space becomes a metric space. The associated norm is called the Euclidean norm.

Sample Output:
Original series:
0     1
1     2
2     3
3     4
4     5
5     6
6     7
7     8
8     9
9    10
dtype: int64
0    11
1     8
2     7
3     5
4     6
5     5
6     3
7     4
8     7
9     1
dtype: int64

Euclidean distance between two said series:
16.492422502470642
Click me to see the sample solution

32. Write a Pandas program to find the positions of the values neighboured by smaller values on both sides in a given series.

Sample Output: 
Original series:
0    1
1    8
2    7
3    5
4    6
5    5
6    3
7    4
8    7
9    1
dtype: int64

Positions of the values surrounded by smaller values on both sides:
[1 4 8]
Click me to see the sample solution

33. Write a Pandas program to replace missing white spaces in a given string with the least frequent character.

Sample Output:
Original series:
abc def abcdef icd
c    3
d    3
     3
b    2
e    2
a    2
f    2
i    1
dtype: int64
abcidefiabcdefiicd
Click me to see the sample solution

34. Write a Pandas program to compute the autocorrelations of a given numeric series.
From Wikipedia:
Autocorrelation, also known as serial correlation, is the correlation of a signal with a delayed copy of itself as a function of delay. Informally, it is the similarity between observations as a function of the time lag between them.

Sample Output:
Original series:
0     13.207262
1      4.098685
2     -1.435534
3     13.626760
...
13    -2.346193
14    17.873884
dtype: float64

Autocorrelations of the said series:
[-0.38, 0.1, -0.43, 0.03, 0.35, -0.2, 0.04, -0.59, 0.34, 0.11]
Click me to see the sample solution

35. Write a Pandas program to create a TimeSeries to display all the Sundays of given year.

Sample Output: 
All Sundays of 2019:
0    2020-01-05
1    2020-01-12
2    2020-01-19
3    2020-01-26
4    2020-02-02
5    2020-02-09
.....
48   2020-12-06 
49   2020-12-13
50   2020-12-20
51   2020-12-27
dtype: datetime64[ns]
Click me to see the sample solution

36. Write a Pandas program to convert given series into a dataframe with its index as another column on the dataframe.

Sample Output:
  index  0
0     A  0
1     B  1
2     C  2
3     D  3
4     E  4
Click me to see the sample solution

37. Write a Pandas program to stack two given series vertically and horizontally.

Sample Output:
Original Series:
0    0
1    1
2    2
....
7    7
8    8
9    9
dtype: int64
0    p
1    q
2    r
....
7    w
8    x
9    y
dtype: object

Stack two given series vertically and horizontally:
   0  1
0  0  p
1  1  q
2  2  r
.....
8  8  x
9  9  y 
Click me to see the sample solution

38. Write a Pandas program to check the equality of two given series.

Sample Output: 
Original Series:
0    1
1    8
2    7
...
7    4
8    7
9    1
dtype: int64
0    1
1    8
2    7
3    5
.....
8    7
9    1
dtype: int64
Check 2 series are equal or not?
0    True
1    True
2    True
....
7    True
8    True
9    True
dtype: bool
Click me to see the sample solution

39. Write a Pandas program to find the index of the first occurrence of the smallest and largest value of a given series.

Sample Output:
Original Series:
0     1
1     3
2     7
.....
7     1
8     9
9     0
dtype: int64
Index of the first occurrence of the smallest and largest value of the said series:
9
4
Click me to see the sample solution

40. Write a Pandas program to check inequality over the index axis of a given dataframe and a given series.

Sample Output: 
Original DataFrame:
      W     X   Y   Z
0  68.0  78.0  84  86
1  75.0  75.0  94  97
2  86.0   NaN  89  96
3  80.0  80.0  86  72
4   NaN  86.0  86  83

Original Series:
0    68.0
1    75.0
2    86.0
3    80.0
4     NaN
dtype: float64

Check for inequality of the said series & dataframe:
       W      X     Y     Z
0  False   True  True  True
1  False  False  True  True
2  False   True  True  True
3  False  False  True  True
4   True   True  True  True
Click me to see the sample solution

Python-Pandas Code Editor:

More to Come !

Do not submit any solution of the above exercises at here, if you want to contribute go to the appropriate exercise page.

Test your Python skills with w3resource's quiz



Become a Patron!

Follow us on Facebook and Twitter for latest update.

It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.

https://198.211.115.131/python-exercises/pandas/index-data-series.php