• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Programming Expert

Solving All of Your Programming Headaches

  • HTML
  • JavaScript
  • jQuery
  • PHP
  • Python
  • SAS
  • Ruby
  • About
You are here: Home / Python / pandas ceil – Find the Ceiling of a Column Using Numpy ceil

pandas ceil – Find the Ceiling of a Column Using Numpy ceil

December 20, 2021 Leave a Comment

To find the ceiling of numbers in a column using pandas, the easiest way is to use the numpy ceil() function.

df["Column"] = df["Column"].apply(np.ceil)

Finding the ceiling of numbers in a column in pandas is easy. We can round up numbers in a column to the nearest integer with the numpy ceil() function.

Let’s say we have the following DataFrame.

df = pd.DataFrame({'Name': ['Jim', 'Sally', 'Bob', 'Sue', 'Jill', 'Larry'],
                   'Weight': [160.20, 123.81, 209.45, 150.35, 102.43, 187.52]})

print(df)
# Output: 
    Name  Weight
0    Jim  160.20
1  Sally  123.81
2    Bob  209.45
3    Sue  150.35
4   Jill  102.43
5  Larry  187.52

To get the ceiling of the numbers in the column “weight”, we can apply the numpy ceil() function in the following way:

df["Ceiling of Weight"] = df["Weight"].apply(np.ceil)

print(df)

# Output:
    Name  Weight  Ceiling of Weight
0    Jim  160.20              161.0
1  Sally  123.81              124.0
2    Bob  209.45              210.0
3    Sue  150.35              151.0
4   Jill  102.43              103.0
5  Larry  187.52              188.0

If you are looking to find the ceiling of a number in regular Python, you can use the Math.ceil() function.

If you want to round down a column to the nearest integer, instead of rounding up, you can use the numpy floor() function.

Hopefully this article has been helpful for you to use the numpy ceil() function to find the ceiling of numbers in a column using pandas in python.

Other Articles You'll Also Like:

  • 1.  Divide Each Element in List by Scalar Value with Python
  • 2.  Check if Character is Letter in Python
  • 3.  Find Index of Maximum in List Using Python
  • 4.  How to Draw a Triangle in Python Using turtle Module
  • 5.  Remove Empty Strings from List in Python
  • 6.  Does Python Use Semicolons? Why Python Doesn’t Use Semicolons
  • 7.  Selenium minimize_window() Function to Minimize Window in Python
  • 8.  Format Numbers as Currency with Python
  • 9.  Get First Key and Value in Dictionary with Python
  • 10.  Sort List of Tuples in Python

About The Programming Expert

The Programming Expert is a compilation of a programmer’s findings in the world of software development, website creation, and automation of processes.

Programming allows us to create amazing applications which make our work more efficient, repeatable and accurate.

At the end of the day, we want to be able to just push a button and let the code do it’s magic.

You can read more about us on our about page.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

About The Programming Expert

the programming expert main image

Welcome to The Programming Expert. We are a group of US-based programming professionals who have helped companies build, maintain, and improve everything from simple websites to large-scale projects.

We built The Programming Expert to help you solve your programming problems with useful coding methods and functions in various programming languages.

Search

Learn Coding from Experts on Udemy

Looking to boost your skills and learn how to become a programming expert?

Check out the links below to view Udemy courses for learning to program in the following languages:

Copyright © 2023 · The Programming Expert · About · Privacy Policy