df.get()
df.get(column_name)
or
df.get([col_1_name, ..., col_k_name])
Returns column(s) from DataFrame.
- Returns:
- Series or DataFrame with the corresponding key(s).
- Return Type:
- Series or DataFrame
- Note:
- Can return a DataFrame with one column by putting the column name in square brackets.
pets
| Index | ID | Species | Color | Weight | Age | Is_Cat | Owner_Comment |
|---|---|---|---|---|---|---|---|
| 0 | dog_001 | dog | black | 40 | 5 | False | There are no bad dogs, only bad owners. |
| 1 | cat_001 | cat | golden | 1.5 | 0.2 | True | My best birthday present ever!!! |
| 2 | cat_002 | cat | black | 15 | 9 | True | ****All you need is love and a cat.**** |
| 3 | dog_002 | dog | white | 80 | 2 | False | Love is a wet nose and a wagging tail. |
| 4 | dog_003 | dog | black | 25 | 0.5 | False | Be the person your dog thinks you are. |
| 5 | ham_001 | hamster | black | 1 | 3 | False | No, thank you! |
| 6 | ham_002 | hamster | golden | 0.25 | 0.2 | False | No, thank you! |
| 7 | cat_003 | cat | black | 10 | 0 | True | No, thank you! |
pets.get('Species')
- 0"dog"
- 1"cat"
- 2"cat"
- 3"dog"
- 4"dog"
- 5"hamster"
- 6"hamster"
- 7"cat"
Get a series as a DataFrame.
pets.get(['Species'])
| Index | Species |
|---|---|
| 0 | dog |
| 1 | cat |
| 2 | cat |
| 3 | dog |
| 4 | dog |
| 5 | hamster |
| 6 | hamster |
| 7 | cat |
pets.get(['Species', 'Color'])
| Index | Species | Color |
|---|---|---|
| 0 | dog | black |
| 1 | cat | golden |
| 2 | cat | black |
| 3 | dog | white |
| 4 | dog | black |
| 5 | hamster | black |
| 6 | hamster | golden |
| 7 | cat | black |
See Also
df.shape · df.columns · df[] · df.set_index()
Problems or suggestions about this page? Fill out our feedback form.