def get_stylo_csv_file(): try: doc_id = int(request.args.get('doc_id')) except ValueError: abort(403) header_row = ['author id', 'document id', 'paragraph id'] + ['feature ' + str(i) for i in range(1, 57)] data_list = data_warehouse.get_cross_tab_features_from_database_by_doc_id(doc_id) string_io = StringIO() cw = csv.writer(string_io) cw.writerow(header_row) for row in data_list: cw.writerow(row) output = make_response(string_io.getvalue()) output.headers['Content-type'] = 'application/csv' output.headers['Content-Disposition'] = 'attachment;filename=doc_{}.csv'.format(doc_id) return output
def fomulate_set_paragraphes(author_id, set_size): document_list = data_warehouse.get_docs_from_database_document_by_author_id(author_id) paragraph_list = [data_warehouse.get_cross_tab_features_from_database_by_doc_id(idx) for idx in document_list] for idx in range(0, len(paragraph_list), set_size): yield paragraph_list[idx:idx + set_size]
from csv_exportation import data_to_csv from data_analysis import data_warehouse header_row = ['author id', 'document id', 'paragraph id'] + ['feature ' + str(i) for i in range(1, 57)] documents = [item['doc_id'] for item in data_warehouse.get_doc_ids_from_database_fact()] data_list = [] for doc_id in documents: data_list.extend(data_warehouse.get_cross_tab_features_from_database_by_doc_id(doc_id)) data_to_csv.write_csvfile_output('stylo_features.csv', header_row, data_list)
from csv_exportation import data_to_csv from data_analysis import data_warehouse header_row = ['author id', 'document id', 'paragraph id'] + ['feature ' + str(i) for i in range(1, 57)] data_list = data_warehouse.get_cross_tab_features_from_database_by_doc_id(2) data_to_csv.write_csvfile_output('output.csv', header_row, data_list)