How To Use Pandas in Django

Learn how to use pandas in Django. In this tutorial, you will learn how to use pandas in Django data. And convert a query set of data into a Data frame. Like how you convert a CSV data file into a Data Frame. And perform the data science operation right away in Django Views.

Requirements :

pip install django
pip install pandas

Creating Model for Query Set Data ( :

from django.db import models

# Create your models here.

class Student(models.Model):
    name = models.CharField(max_length=200)
    rollnum = models.IntegerField()
    rank = models.IntegerField()

Register model in Admin page in ( :

from django.contrib import admin
from django.contrib.admin.decorators import register
from .models import *
# Register your models here.

Creating View in ( :

from django.shortcuts import render
from .models import*
import pandas as pd
# Create your views here.
def home(request):
    item = Student.objects.all().values()
    df = pd.DataFrame(item)
    mydict = {
        "df": df.to_html()
    return render(request, 'index.html', context=mydict)

Html Template Code for Data frame display in table format :