3000 explained code solutions for 75 technologies


python-pandasHow to floor values in dataframe


import pandas as pd
import numpy as np

df = pd.DataFrame({
  'phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
  'price': [204.10, 304.99, 404.5, 405.5, 305.90]
})

df['price'] = df['price'].apply(np.floor)ctrl + c
import pandas as pd

load Pandas module

pd.DataFrame

creates Pandas DataFrame object

.apply(

applies given callback to all values of given column (or multiple columns)

np.floor

Numpy module floor function


Usage example

import pandas as pd
import numpy as np

df = pd.DataFrame({
  'phone': ['ip5', 'ip6', 'ip8', 'sms', 'xi'],
  'price': [204.10, 304.99, 404.5, 405.5, 305.90]
})

df['price'] = df['price'].apply(np.floor)
print(df)
output
  phone  price
0   ip5  204.0
1   ip6  304.0
2   ip8  404.0
3   sms  405.0
4    xi  305.0