python-pandasHow to keep only certain columns in dataframe
In order to keep only specific columns, we can select needed columns and overwrite our dataframe:
import pandas as pd
df = pd.DataFrame({
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Price': [204, 304, 404, 405, 305],
'Color': ['red', 'red', 'gray', 'black', 'red']
})
df = df[['Phone', 'Color']]ctrl + cimport pandas as pdload Pandas module | pd.DataFramecreates Pandas DataFrame object |
['Phone', 'Color']list of columns to keep in | |
Usage example
import pandas as pd
df = pd.DataFrame({
'Phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
'Price': [204, 304, 404, 405, 305],
'Color': ['red', 'red', 'gray', 'black', 'red']
})
df = df[['Phone', 'Color']]
print(df)output
Phone Color
0 ip5 red
1 ip6 red
2 ip8 gray
3 sms black
4 xi red
More of Python Pandas
- How to use melt() with dataframe - example
- How to set data frame index
- Get current year
- How to floor values in dataframe
- What is opposite of melt() in Pandas
- How to load dataframe from Excel (XSL)
- How to replace values in dataframe
- How to drop duplicates from dataframe
- How to convert column object values to String
- How to round all values in dataframe
See more codes...