how can i convert string to float in python 3

Question

so i am struggling on understanding converting string to float in python.

i am using a csv file and i want each row of item to be a list, the food name to be a string, the carbs to be a string, and calories to be float

i don't understand how to do that i am trying this:

def menu_list(filep):
    """Function to read the csv file, create a nested list and return the list that is sorted based on calories in the ascending order."""

    menulist = [] #store items
    with open(filep) as csv_file: #read file
        csv_reader = csv.reader (csv_file, delimiter=',')
        next(csv_reader, None)

        mlist = []
        for row in csv_reader:
            row = str
            row[2] = float()
            print (row)

    menulist.sort(key=lambda x: x[1])
    return menulist

every time i run this it give me the error : 'type' object does not support item assignment

can someone help me fix my code and convert string to float?

what does your csv file look like? Can you give a few lines as an example? — Axe319
– Axe319, Commented May 26, 2020 at 18:15

Axe319 · Accepted Answer · 2020-05-26 18:33:50Z

1

You are doing nothing with your csv output. To answer your main question you can use my_float = float(my_str)

In your example, you are asking how to convert an individual column in your csv. This is dependent on your data. Say you have a csv row like this.

"Apple","25 g",95

Since your float is unquoted it's really helpful when parsing the csv. We can simply specify unquoted as numeric in our csv.reader() object.

import csv

def menu_list(filep):
    """
    Function to read the csv file, 
    create a nested list and return the list that is 
    sorted based on calories in the ascending order.
    """

    menulist = [] #store items
    with open(filep) as csv_file: #read file
        csv_reader = csv.reader(csv_file, 
                                delimiter=',', 
                                quotechar='"', 
                                quoting=csv.QUOTE_NONNUMERIC)
        next(csv_reader, None)

        for row in csv_reader:
            menulist.append(row)

    menulist.sort(key=lambda x: x[1])
    return menulist

However, if all or none of your columns in your csv are quoted, you'll have to parse as you're appending

"Apple","25 g","95"

or

Apple,25 g,95

import csv

def menu_list(filep):
    """
    Function to read the csv file, 
    create a nested list and return the list that is 
    sorted based on calories in the ascending order.
    """

    menulist = [] #store items
    with open(filep) as csv_file: #read file
        csv_reader = csv.reader(csv_file, delimiter=',')
        next(csv_reader, None)

        for row in csv_reader:
            row[2] = float(row[2].strip())
            menulist.append(row)

    menulist.sort(key=lambda x: x[1])
    return menulist

answered May 26, 2020 at 18:33

Axe319

4,3853 gold badges19 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user202729 Over a year ago

Is there any way so that it converts float to int if there isn't any decimal point?

user202729 Over a year ago

(apart from the obvious solution int(x) if isinstance(x, float) and x.is_integer() else x (stackoverflow.com/questions/6209008/…)

farukaygun · Accepted Answer · 2020-05-26 12:31:36Z

0

You can convert string to float easily.

string_num = "555.555"
print(float(string_num)) #It's float now.

If there is non-number your variable, you can use regex. Take a look here

answered May 26, 2020 at 12:31

farukaygun

3183 silver badges18 bronze badges

1 Comment

prvrlx Over a year ago

i get this one but inside a csv file i need to make the items to be a string the other item to be int and the an item which is a string to be a float

Collectives™ on Stack Overflow

how can i convert string to float in python 3

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related