Я пытаюсь получить запрос на основе выбора пользователей, например даты, группы и символа. Я хочу преобразовать этот набор запросов в фрейм данных, используя Django pandas. Я попытался преобразовать сгенерированный фрейм данных в объект JSON, но он выдает:
TypeError: объект типа DataFrame не является сериализуемым JSON.
class StockPriceDataViewSet(mixins.ListModelMixin,
viewsets.GenericViewSet):
queryset = StockPriceData.objects.all()
serializer_class = StockPriceDataSerializer
filter_backends = [DjangoFilterBackend, SearchFilter]
filterset_fields = {
'date':['gte','lte'],
'org__symbol':['exact'],
'org__group':['exact'],
}
permission_classes = (AllowAny,)
def get_queryset(self):
queryset = super(StockPriceDataViewSet, self).get_queryset()
result = generate_df(queryset=queryset)
return queryset, result
def generate_df(queryset):
df = queryset.to_dataframe()
df = df.drop(['s_n'], axis=1)
df = df.set_index(['org','id'],inplace=True)
result = df.to_json()
return result
В интерактивной оболочке он работает без ошибок, но когда Django обрабатывает запрос:
Объект «NoneType» не имеет атрибута «to_json»
Кроме того, формат JSON не является стандартным, как я ожидал. Что я делаю не так?
Трассировка стека:
AttributeError at /api/v1/stock/price/
'tuple' object has no attribute 'model'
Request Method: GET
Request URL: http://localhost:8000/api/v1/stock/price/?page=1
Django Version: 3.0
Python Executable: /home/anjaan/project/fintech/venv/bin/python
Python Version: 3.8.5
Python Path: ['/home/anjaan/project/fintech', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/anjaan/project/fintech/venv/lib/python3.8/site-packages']
Server time: Wed, 17 Feb 2021 05:49:42 +0000
Installed Applications:
['django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.sites',
'drf_yasg',
'rest_framework',
'rest_framework.authtoken',
'rest_framework_swagger',
'rest_framework_jwt',
'rest_auth',
'allauth',
'allauth.account',
'django_extensions',
'django_rest_passwordreset',
'django_filters',
'channels',
'users',
'misc',
'notification',
'finance']
Installed Middleware:
['django.middleware.security.SecurityMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'fintech.middleware.UserAgentMiddleware',
'fintech.middleware.UserActivityLogMiddleware']
Traceback (most recent call last):
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django/core/handlers/exception.py", line 34, in inner
response = get_response(request)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django/core/handlers/base.py", line 115, in _get_response
response = self.process_exception_by_middleware(e, request)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django/core/handlers/base.py", line 113, in _get_response
response = wrapped_callback(request, *callback_args, **callback_kwargs)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
return view_func(*args, **kwargs)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/viewsets.py", line 125, in view
return self.dispatch(request, *args, **kwargs)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/views.py", line 509, in dispatch
response = self.handle_exception(exc)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/views.py", line 469, in handle_exception
self.raise_uncaught_exception(exc)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
raise exc
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/views.py", line 506, in dispatch
response = handler(request, *args, **kwargs)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/mixins.py", line 38, in list
queryset = self.filter_queryset(self.get_queryset())
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/rest_framework/generics.py", line 150, in filter_queryset
queryset = backend().filter_queryset(self.request, queryset, self)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django_filters/rest_framework/backends.py", line 90, in filter_queryset
filterset = self.get_filterset(request, queryset, view)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django_filters/rest_framework/backends.py", line 31, in get_filterset
filterset_class = self.get_filterset_class(view, queryset)
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django_filters/rest_framework/backends.py", line 73, in get_filterset_class
class AutoFilterSet(self.filterset_base):
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django_filters/rest_framework/backends.py", line 74, in AutoFilterSet
class Meta(MetaBase):
File "/home/anjaan/project/fintech/venv/lib/python3.8/site-packages/django_filters/rest_framework/backends.py", line 75, in Meta
model = queryset.model
Exception Type: AttributeError at /api/v1/stock/price/
Exception Value: 'tuple' object has no attribute 'model'
