Change a ' , ' by a ' . ' in csv file with python

Hello I want to replace the comma in a column of an excel file with points in my python program and I want my column to be a list.

My code:

id1= row[1]
id4 = []          
absence = []


for row in range(1,360):
      absence.append(float(feuille_1.cell_value(row, 10)))
      id4.append(id1)


result2 = {}
    for name2 in set(id4):
    result2[name2] = 0


for i in range(len(id4)):
      hours2 = float(absence[i])
      name2 = id4[i]
      result2[name2] += hours2

     print(result2)


I have this following error :

absence.append(float(feuille_1.cell_value(row, 10)))
ValueError: could not convert string to float: 

I show you my exel file :

And i want to tranform all of my column to an float to execute my code. The specific column that i want to deal with is :


Maybe you try to convert a empty value. Make Try and Except , check if the cellule is empty or no .

Official USPS Change of Address Form, This is the official site for changing your address with the United States Postal Service (USPS). Complete your change of address online & pay only $1.05. Change.org is the world’s largest petition platform, using technology to empower more than 200 million users to create the change they want to see.


To deal with excel file or csv in python, a good tool to use is the pandas package. It allows you to create a so called DataFrame with the same number of columns than your excel file and do all kind of operations on it. You can also specify the decimal delimiter when opening the csv file. For example if your delimiter is a ';' and the decimal delimiter is ',' open your csv using:

import pandas as pd
df = pd.read_csv('path/to/your/csv/file', decimal=',', delimiter=';')

Then in df you will have your excel data. to select one column (myCol in the following you just have to do :

val = df.myCol.tolist() 

and the values of your column will be stored in a list.

Official USPS Change of Address Form, This is the official site for changing your address with the United States Postal Service (USPS). Complete your change of address online & pay only $1.05. Make a difference by starting your petition today. Change.org is a free, easy to use platform that connects you to a community of over 180 million passionate members.


I know where is my mistake it's because the list begin at :

['', '', '', '', 'Jours', '1,00',

And i want that she begin at ;

 ['1,00', '2,00', '1,00', '1,00', '1,00', '1,00'

Change or reset your password - Android, Change your password. On your Android phone or tablet, open your device's Settings app and then Google and then Manage your Google Account. Changing a will to reflect these new wishes is important. New or disposed of assets: If in your will you leave all of your property or a percentage of your property to your heirs, then when what you own changes, there is no need to change your will.


Change the email address for your account - Android, Change the email address for your account. In some cases, you can use a different email address (username) to identify your Google Account. The easiest was to change a file's extension is to save the file as a different file type from within a software program. Changing the file extension in the file name won't change the file type, but will cause the computer to misidentify the file. In Windows and Mac OS X, file extensions are often hidden.


Topic No. 157 Change Your Address – How to Notify the IRS , Send your written address change information to the IRS addresses listed in the instructions to the tax forms you filed. Separated - If you filed a� Business owners and other authorized individuals can submit a name change for their business. The specific action required may vary depending on the type of business. If the EIN was recently assigned and filing liability has yet to be determined, send Business Name Change requests to IRS, Stop 6055, Kansas City, MO 64999.


Address Changes, Unauthorized third parties can't change a taxpayer's address. Changes of address through the U.S. Postal Service (USPS) may update your address of record on� Modify or change your existing flight reservation. Based on data available on the airlines' websites as of September 2019 and the airlines' lowest unbundled domestic main cabin fare for Customers without status or qualified circumstances: Change fees shown are those charged prior to the day of departure.