﻿ Pandas Practice Set-1: Access a specified Series index and the Series values of diamonds DataFrame - w3resource

# Pandas Practice Set-1: Access a specified Series index and the Series values of diamonds DataFrame

## Pandas Practice Set-1: Exercise-45 with Solution

Write a Pandas program to access a specified Series index and the Series values of diamonds DataFrame.

Sample Solution:

Python Code:

``````import pandas as pd
print("Original Dataframe:")
print("\nAccess the Series index:")
print(diamonds.carat.value_counts().index)
print("\nAccess the Series values:")
print(diamonds.carat.value_counts().values)
``````

Sample Output:

```Original Dataframe:
carat      cut color clarity  depth  table  price     x     y     z
0   0.23    Ideal     E     SI2   61.5   55.0    326  3.95  3.98  2.43
1   0.21  Premium     E     SI1   59.8   61.0    326  3.89  3.84  2.31
2   0.23     Good     E     VS1   56.9   65.0    327  4.05  4.07  2.31
3   0.29  Premium     I     VS2   62.4   58.0    334  4.20  4.23  2.63
4   0.31     Good     J     SI2   63.3   58.0    335  4.34  4.35  2.75

Access the Series index:
Float64Index([ 0.3, 0.31, 1.01,  0.7, 0.32,  1.0,  0.9, 0.41,  0.4, 0.71,
...
2.65, 3.05, 2.71, 3.22, 4.13,  2.7, 3.67, 5.01, 2.77,  3.4],
dtype='float64', length=273)

Access the Series values:
[2604 2249 2242 1981 1840 1558 1485 1382 1299 1294 1258 1189 1127  910
883  817  807  793  764  709  706  670  667  645  625  572  570  523
496  492  492  488  475  473  440  430  398  394  381  373  361  342
322  310  308  300  293  287  284  282  279  278  265  254  253  251
251  251  249  246  246  236  233  228  226  220  215  212  212  207
204  200  198  187  187  178  177  174  172  155  149  146  142  140
135  134  133  131  130  126  124  123  122  122  119  110  110  109
106  106  103  102  101   99   95   89   89   89   87   86   80   77
68   67   65   65   64   64   63   62   61   60   59   59   57   52
52   50   50   50   50   50   48   48   48   46   45   45   43   43
41   40   40   36   34   32   32   31   31   31   30   28   27   26
26   25   25   25   25   25   24   23   23   23   22   22   21   21
21   21   21   20   19   19   18   18   18   18   18   17   17   17
17   16   16   15   15   15   14   13   13   13   13   12   12   12
12   11    9    9    9    9    9    9    9    8    8    8    8    8
7    7    7    7    7    6    6    6    5    5    5    5    4    4
4    4    4    4    4    3    3    3    3    3    3    3    3    3
3    3    3    3    3    3    3    3    2    2    2    2    2    2
1    1    1    1    1    1    1    1    1    1    1    1    1    1
1    1    1    1    1    1    1]
```

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

What is the difficulty level of this exercise?

﻿

Inviting useful, relevant, well-written and unique guest posts