python - Pandas DataFrame 到 Django API

Question

我正在使用 pyodbc + pandas 来分析数据，我想知道如何在 Django 中存储最终的数据帧。

cnxn = pyodbc.connect('DSN=DATABASE;UID=USERNAME;PWD=PASSWORD')
cursor = cnxn.cursor()

qry = "SELECT * FROM SECURITIES"
df = pd.read_sql(qry, cnxn)

*do some manipulation*

df_final

ticker    beta
ABC       1.2
XYZ       0.8

我已经设置了模型和序列化器，但我不知道如何将数据帧推送到这个模型中。

class Stocks(models.Model):
    ticker = models.CharField(max_length=16)
    beta = models.FloatField()

    def __str__(self):
        return self.ticker

class TickerSerializer(serializers.ModelSerializer):

    class Meta:
        model = Ticker
        fields = ('ticker', 'beta')

Answer 1

这成功了:

from django.db import models
from django.conf import settings
from .available import df_available
import sqlite3

engine = settings.DATABASES['default']['NAME']

# Create your models here.
class Stocks(models.Model):
    ticker = models.CharField(max_length=16, primary_key=True)
    beta = models.FloatField(default=1.0)

    def __str__(self):
        return self.ticker

cnxn = sqlite3.connect(engine)

df_final.to_sql('api_stocks', con=cnxn, if_exists='replace', index=False)