How to save and download a csv file in django

-

 

import pandas as pd
 
def Category1_csv(request):

category1=Database.objects.all()
file=[]

for i in category1:
p=i.abc
row=[p,...]
file.append(row)
    #to save a file
document = pd.DataFrame(file)
document.to_csv('media/file_downloads/category1.csv')
#return HttpResponse("file createrd")
    # to download a file
data = open(os.path.join(settings.BASE_DIR,'media/file_downloads/category1.csv'),'r').read()
resp =HttpResponse(data)
resp['Content-Disposition'] = 'attachment;filename=csv file.csv'
return resp


 

Comments

Post a Comment

Popular posts from this blog

Exporting HTML Page into PDF In Django

-
Views.py from django.shortcuts import render from io import BytesIO from django.http import HttpResponse from django.template.loader import get_template from xhtml2pdf import pisa   from django.views import generic import pandas as pd # Create your views here. # defining the function to convert an HTML file to a PDF file def html_to_pdf ( template_src , context_dict ={}):      template = get_template(template_src)      html  = template.render(context_dict)      result = BytesIO()      pdf = pisa.pisaDocument(BytesIO(html.encode( "ISO-8859-1" )), result)       if not pdf.err:           return HttpResponse(result.getvalue(), content_type = 'application/pdf' )       return None class GeneratePdf ( generic . View ):       def get ( self , request , * args , ** kwargs ):                   ...
Read more

C PROGRAMMING LANGUAGE

-
PART 1: OPERATORS IN C LANGUAGE OPERATORS IN C LANGUAGE An operator is a symbol that operates on a value or a variable. For example: + is an operator to perform addition. C has a wide range of operators to perform various operations. Relational Operators Logical Operators Assignment Operator Decrement and increment Comma Operator sizeof Operator C Arithmetic Operators An arithmetic operator performs mathematical operations such as addition, subtraction, multiplication, division etc on numerical values (constants and variables). Operator Meaning of Operator + addition or unary plus - subtraction or unary minus * Multiplication / Division % remainder after division (modulo division) C Increment and Decrement Operators C programming has two operators increment ++ and decrement -- to change the value of an operand (constant or variable) by 1. Increment ++ increases the value by 1 whereas decrement -- decreases the value by 1. These two operators are unary operators, meaning the...
Read more