filterrific | Rails Engine plugin that makes it easy to filter search | Widget library

note: I'm not a programmer by any means, but I've been asking questions and doing tutorials to try to understand how to get a solution for my issues, outside of therapy.

Anyway, I have a script that downloads .csv files and then imports them into a Postgres database. I noticed that the .csv's were having a lot of "float" data types and I needed those to be integers so I found the following snippet and was using it. I was learning how to use pandas and I'm getting an error on the

df.iloc[index, c] = int(x) line.

it's showing "ValueError: cannot convert float NaN to integer"

I ended up commenting out a few lines in that snippet and it works but it's turning columns into float and adding .0.

in my head, I'm thinking I'm not identifying the right columns but I'm not sure how to tell.

If I comment out everything under the duplicated line and above the return df line.. it runs without error but the data isn't accurate. It's showing float data in fields that should just be integers.

I'm thinking that I need to be identifying every column that needs to be looked at as a float and make it an integer, but not sure how to do that in a script so it looks at anything downloaded and fixes that. Because I'm having the script log into a site and download .csv files and then print them and put them into postgres.