Python convert float to int if decimal is 0

I have a pandas dataframe, in which some columns have numeric values while others don't, as shown below:

City          a     b       c
Detroit       129   0.54    2,118.00
East          188   0.79    4,624.4712
Houston       154   0.65    3,492.1422
Los Angeles   266   1.00    7,426.00
Miami         26    0.11    792.18
MidWest       56    0.24    772.7813

I want to round off these numeric values to 2 decimal places, for which I am using:

df = df.replace(np.nan, '', regex=True)

After which df becomes:

City          a       b       c
Detroit       129.0  0.54   2,118.0
East          188.0  0.79   4,624.47
Houston       154.0  0.65   3,492.14
Los Angeles   266.0  1.0    7,426.0
Miami         26.0   0.11   792.18
MidWest       56.0   0.24   772.78

It works mostly fine, but it also converts proper integers to decimals, i.e., values like 100 are rounded off to 100.0. I want the dataframe like this:

City          a       b         c
Detroit       129    0.54      2,118
East          188    0.79      4,624.47
Houston       154    0.65      3,492.14
Los Angeles   266    1         7,426
Miami         26     0.11      792.18
MidWest       56     0.24      772.28

I want to keep such values as proper integers itself, while rounding off others to 2 decimal places in all the numeric columns. How can I do that?

Converting a float value to an int is done by Type conversion, which is an explicit method of converting an operand to a specific type. However, it is to be noted that such type of conversion may tend to be a lossy one (loss of data). Converting an int value like 2 to floating-point will result in 2.0, such types of conversion are safe as there would be no loss of data, but converting 3.4 to an int value will result in 3 leading to a lossy conversion. 
Examples: 

Input:  3.3 
Output: 3 

Input:  5.99
Output: 5

Method 1: Conversion using int():

To convert a float value to int we make use of the built-in int() function, this function trims the values after the decimal point and returns only the integer/whole number part.

Syntax: int(x) 

Return: integer value

Example 1: Number of type float is converted to a result of type int.

Python3

num = 9.3

print('type:',

      type(num).__name__) 

num = int(num)  

print('converted value:', num,

      ', type:', type(num).__name__)

Output

type: float
converted value: 9 , type: int

Example 2: In most cases the int() function rounds off the result to an integer lesser than or equal to the input, but the behavior is neither definite nor predictable. One such example is shown below.

Python3

num1 = 5.9

num2 = 5.99999999999999999999

num1 = int(num1)

num2 = int(num2)

print(num1, num2, sep = '\n')

Method 2: Conversion using math.floor() and math.ceil().

A float value can be converted to an int value no larger than the input by using the math.floor() function, whereas it can also be converted to an int value which is the smallest integer greater than the input using math.ceil() function. The math module is to be imported in order to use these methods.

Syntax: math.floor(x)

Parameter:

x: This is a numeric expression.

Returns: largest integer not greater than x.

Syntax: math.ceil(x)

Parameter:

x: This is a numeric expression.

Returns: Smallest integer not less than x.

Example : In the below example conversion from float to int has been achieved using the floor() and ceil() methods, the former returns an int no larger than the input and the latter returns the smallest integer larger than the input.

Python3

import math      

num = 5.6

floor_value = math.floor(num)

ceil_value  = math.ceil(num)

print("the result using floor() : ",

      floor_value ,

      ', type : ',type(floor_value).__name__)

print("the result using ceil()  : ",

      ceil_value,

      ', type: ', type(ceil_value).__name__)

Output

the result using floor() :  5 , type :  int
the result using ceil()  :  6 , type:  int

Method#3: Conversion using round( ).

A float value can be converted to an int value which is closet integer value if does not pass second parameter. In case of equal difference it goes toward larger integer.

Syntax: round(x)

Parameter:

x: This is a numeric expression.

Returns: integer multiple of closest.

Example : In the below example conversion from float to int has been achieved using the round() methods, the former returns an int number which is closest to number.

Python3

num = 5.6

print( 'Type : ', type(num).__name__)

print( "Original number is : ", num)

value = round(num)

print( 'Type : ',type(value).__name__)

print("the result using round  : ",value)

Output

Type :  float
Original number is :  5.6
Type :  int
the result using round  :  6

Method#4: Conversion using math.trunc( ).

A float value can be converted to an int value. In case of negative number it behaves like ceiling function of math library and in case of positive number it behaves like floor function..

Syntax: math.trunc(x)

Parameter:

x: This is a numeric expression.

Returns: larger integer in case of negative number else in case of positive number smaller number.

Example : In the below example conversion from float to int has been achieved using the math.trunc() methods, the former returns an larger int number which in case of negative number, else in case of positive number return smaller integer number.

Python3

import math

num = 5.6

num2 = -2.6

value = math.trunc(num2)

print( 'Type of value : ',type(value).__name__)

print("the result using round  : ",value)

data = math.trunc(num)

print( 'Type of data: ',type(data).__name__)

print("the result using round  : ",data)

Output

Type of value :  int
the result using round  :  -2
Type of data:  int
the result using round  :  5

How do you change a float to an int in Python?

Can you use a float as an int Python?

How do you convert a decimal to an integer in Python?

How do you get no decimals in Python?