I want to do some math on a dataframe but (I think) can't get one column/series into the necessary format. The column contains strings; some are '.123' while others are '0'. When I attempt the math on the column of strings by converting everything to an integer like so:

dfteam1['cloff'] = dfteam1.cloff.astype(int)

I get the following error

ValueError: invalid literal for int() with base 10: '.123'

I think it's b/c .123 isn't an integer but a float, so I change the code like so:

dfteam1['cloff'] = dfteam1.cloff.astype(float)

now I get the following error

ValueError: could not convert string to float:

I think it's b/c 0 isn't a float but an integer? Do I need to change all the 0 values to 0.00 or am I completely off base? All feedback is welcome.

I have a list of strings and I would to get the average of the list. so I need to convert those strings in the list into float but I keep getting this:

ValueError: could not convert string to float: '"104.8"\n' 

How do I solve it? Thanks

THIS IS MY TASK:

Read the number list from file and convert it into an array. 2. Create a counter and set it to zero. 3. Create a for loop that traverses the number array. 4. Inside the for loop, check if the current number is less than the next number. 5. If the current number is less than the next number, decrement the counter. 6. After the for loop finishes traversing, return the counter.

THIS IS MY CODE:

with open("numbers.txt") as file:
    numbers = [
        float(line)
for line in file
    ]
count = 0
for idx, number in enumerate(numbers[:-1]):
if number < numbers[idx+1]:
        count += 1
print(count)

AND THIS IS MY ERROR:

Exception has occurred: ValueError

could not convert string to float: '\n'

i really have no idea how to fix it