python - Parse Beautifulsoup output to csv file for download -


this question has answer here:

i've gone through questions on site , googled struggling take beautifulsoup output (which appear lists) , return in csv format user of flask app can download in browser. here's code:

html = col_result.__html__() bs = beautifulsoup(html) table = bs.find(lambda tag: tag.name == 'table') headers = table.findall(lambda tag: tag.name == 'th') rows = table.findall(lambda tag: tag.name == 'tr')  open('export_file.csv', 'w+', newline='') f:     file = csv.writer(f)     file.writerow(headers)     file.writerows(rows) rfile = csv.reader(open('export_file.csv', newline=''))  return response(     rfile,     mimetype="text/csv",     headers={"content-disposition":              "attachment; filename=export_file.csv"})

the csv file blank when downloaded. have imported csv & bs4 modules. can advise how produce raw csv data html can passed 'rfile' variable in return response() section of code cannot work?

for example if iterate through csv.reader object , print each line get,

['firstname', 'surname', 'department', 'manager', 'absence periods', 'late instances'] ['renata', 'krzysik', 'gifts', 'michael de jäger', '0 absence', '0 lateness']...

...but cant work out how parse csv format (without lists , html tags)and assign rfile variable?

the first parameter of response class should be

response – string or response iterable

so don't think can pass csv.reader parameter. try pass string content of file instead.

or can use make_response , pass contents of csv file it:

from flask import make_response  html = col_result.__html__() bs = beautifulsoup(html) table = bs.find(lambda tag: tag.name == 'table') headers = table.findall(lambda tag: tag.name == 'th') rows = table.findall(lambda tag: tag.name == 'tr')  open('export_file.csv', 'w+', newline='') f:     file = csv.writer(f)     file.writerow(headers)     file.writerows(rows)  open('export_file.csv', 'r') csv:     response = make_response(csv.read())     response.headers["content-disposition"] = "attachment; filename=books.csv"     return response

-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more