Getting 'ValueError'

  • Vishal
  • Topic Author
More
17 Aug 2023 10:56 #12428 by Vishal
Getting 'ValueError' was created by Vishal
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?

Please Log in or Create an account to join the conversation.

  • Paul Gilman
More
17 Aug 2023 23:40 - 17 Aug 2023 23:40 #12436 by Paul Gilman
Replied by Paul Gilman on topic Getting 'ValueError'
Hi Vishal,

I think this is a general Python question rather than one about PySAM. If it is about PySAM, please describe the PySAM context if you would like to help me troubleshoot. For example, perhaps the 'data.csv' file contains data generated by PySAM -- if it does, it would be helpful to have a copy of the file.

Best regards,
Paul.
Last edit: 17 Aug 2023 23:40 by Paul Gilman.

Please Log in or Create an account to join the conversation.

Moderators: Paul Gilman
Powered by Kunena Forum