Python - passing items from a list as columns for pandas read_csv method

Question

I want to convert to a single html file, several values that are inputted from a webform. This the code I have right now

formData = cgi.FieldStorage()
my_file = formData.getvalue("my_filename")
my_col = formData.getlist("column")

print(my_col) #list

for item in my_col:
    csvdata = pandas.read_csv(my_file, usecols=[item])

#cd = csvdata.to_html()
#...

Obviously this only converts to html the last item in the list. How can I convert every item in my_col list in a single html file?

Yogesh Bhandari · Accepted Answer · 2021-06-27 05:12:32Z

1

You are only getting the last element because you are looping through my_cols. You don't need to do that, instead, send the whole list my_cols to usecols as follows and you will get the desired result.


formData = cgi.FieldStorage()
my_file = formData.getvalue("my_filename")
my_col = formData.getlist("column")

print(my_col) #list

csvdata = pandas.read_csv(my_file, usecols=my_col)

answered Jun 27, 2021 at 5:12

Yogesh Bhandari

4802 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

Python - passing items from a list as columns for pandas read_csv method

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related