How to Convert float64 Columns to int64 in Pandas?

Last Updated : 11 Jul, 2024

float64 represents a floating-point number with double precision and int64 represents a 64-bit integer number. In this article, we will learn to Convert float64 Columns to int64 in Pandas using different methods

Convert float64 Columns to int64 in Pandas DataFrame

To transform a Pandas column to an integer type within a DataFrame, you have the option to utilize either the DataFrame's astype(int) or the apply() method. This enables the conversion of a column from various data types such as float or string to an integer type, specifically int64 or int32.

1. Using astype() Method

We can use astype() method in Python to convert float64 Columns to int64 in Pandas.

In this example, we create a data frame with floating values and then we convert floating values into integer values using astype() function, This function converts the datatype to another datatype.

Python

import pandas as pd  # Create a sample DataFrame data = {'A': [1.0, 2.0, 3.0],         'B': [4.0, 5.0, 6.0]} df = pd.DataFrame(data)  print(&quot;Before converting&quot;) print(df.dtypes)  # Convert float64 columns to int64 using astype() df['A'] = df['A'].astype('int64') df['B'] = df['B'].astype('int64')  print(&quot;\nAfter converting&quot;) # Check the data types of columns print(df.dtypes)

Output:

Before converting
A    float64
B    float64
dtype: object
After converting
A    int64
B    int64
dtype: object

As you can observe the float64 values in the dataset are converted to int64 datatype.

2. Using apply() and astype() function

We can use the apply() method along with the astype(int) function to convert the columns of the Pandas DataFrame to integers.

Python

import pandas as pd data = {'A': [1.0, 2.4, 3.0],         'B': [4.0, 5.0, 6.5]}  print(&quot;Before converting&quot;) print(df.dtypes) # Use apply method to convert Pandas columns to int df_int = df.apply(lambda column: column.astype(int))  # Check the data types of columns print(&quot;\nAfter converting&quot;) print(df_int.dtypes)

Output:

Before converting
A    float64
B    float64
dtype: object
After converting
A    int64
B    int64
dtype: object

As you can observe the float64 values in the dataset are converted to int64 datatype.

Conclusion

In conclusion,we can Convert float64 Columns to int64 in Pandas within few clicks.

How to convert Float to Int in Python?

hanishj

Improve

Article Tags :

Pandas

Pandas is a powerful tool which is used for data analysis and is built on top of the python library. The Pandas library enables users to create and manipulate dataframes (Tables of data) and time series effectively and efficiently. These dataframes can be used for training and testing machine learni

2 min read

How To Convert Pandas Column To List

One of the common tasks when working with a DataFrame in Pandas is converting a column to a list. In this article we will learn how to convert a Pandas column to a list using various methods. 1. Using tolist()One can convert a pandas column to a list using tolist() function which works on the Pandas

4 min read

How to convert Float to Int in Python?

In Python, you can convert a float to an integer using type conversion. This process changes the data type of a value However, such conversions may be lossy, as the decimal part is often discarded. For example: Converting 2.0 (float) to 2 (int) is safe because here, no data is lost.But converting 3.

5 min read

How to Convert Pandas Columns to String

Converting columns to strings allows easier manipulation when performing string operations such as pattern matching, formatting or concatenation. Pandas provides multiple ways to achieve this conversion and choosing the best method can depend on factors like the size of your dataset and the specific

3 min read

Convert a Dataframe Column to Integer in Pandas

Converting DataFrame columns to the correct data type is important especially when numeric values are mistakenly stored as strings. Let's learn how to efficiently convert a column to an integer in a Pandas DataFrame Convert DataFrame Column to Integer - using astype() Methodastype() method is simple

3 min read

Convert the data type of Pandas column to int

In this article, we are going to see how to convert a Pandas column to int. Once a pandas.DataFrame is created using external data, systematically numeric columns are taken to as data type objects instead of int or float, creating numeric tasks not possible. We will pass any Python, Numpy, or Pandas

2 min read

How to Drop Index Column in Pandas?

When working with Pandas DataFrames, it's common to reset or remove custom indexing, especially after filtering or modifying rows. Dropping the index is useful when: We no longer need a custom index.We want to restore default integer indexing (0, 1, 2, ...).We're preparing data for exports or transf

2 min read

How to convert pandas DataFrame into JSON in Python?

JSON (JavaScript Object Notation) is a lightweight, easily readable format widely used for data interchange between applications, making it ideal for sharing data across different systems. With Pandas, converting a DataFrame into JSON is simple and efficient using the to_json() function. This articl

7 min read

How to Convert Integer to Datetime in Pandas DataFrame?

Let's discuss how to convert an Integer to Datetime in it. Now to convert Integers to Datetime in Pandas DataFrame. Syntax of Â pd.to_datetimedf['DataFrame Column'] = pd.to_datetime(df['DataFrame Column'], format=specify your format)Create the DataFrame to Convert Integer to Datetime in Pandas Check

2 min read

Convert Pandas Dataframe Column To Float

Converting columns to floats in Pandas DataFrame is a very crucial step for data analysis. Converting columns to float values can help you perform various arithmetic operations and plot graphs. In this article, weâ€™ll look at different ways to convert a column to a float in DataFrame. Using DataFrame

6 min read

How to Convert float64 Columns to int64 in Pandas?

Convert float64 Columns to int64 in Pandas DataFrame

1. Using astype() Method

2. Using apply() and astype() function

Conclusion

Similar Reads