mark01
08-17-2023, 11:49 PM
Input contains NaN, infinity or a value too large for dtype('float64')' when trying to perform a groupby operation on my DataFrame. Here's my code snippet:
import pandas as pd
# Load data from CSV
data = pd.read_csv('data.csv')
# Perform groupby operation
grouped = data.groupby('category')['value'].sum()
I've checked for NaN or infinity values in 'value' column using data['value'].isnull().sum() and data['value'].isinf().sum() which both returned 0. What could be causing this error and how can I resolve it?
import pandas as pd
# Load data from CSV
data = pd.read_csv('data.csv')
# Perform groupby operation
grouped = data.groupby('category')['value'].sum()
I've checked for NaN or infinity values in 'value' column using data['value'].isnull().sum() and data['value'].isinf().sum() which both returned 0. What could be causing this error and how can I resolve it?