Tagged Questions

1
vote
0answers
27 views

Data analysis and modelling methodologies in python

Backstory* I have recently switched from using excel to produce models of predicting the chance of being diagnosed with a particular cancer. The model was produced in an excel file and grew in both ...
0
votes
1answer
48 views

Floats, Decimals, Prices, and partial quantities

While the problem in this particular instance deals with Django and Python, I imagine this problem has shown up elsewhere as well. Float values have a precision problem, and when used for currency ...
0
votes
1answer
21 views

Python - How to print Sqlite table

Here I have some simple python code to query a sqlite3 database. import sqlite3 as lite conn = lite.connect('db/posts.db') cur = conn.cursor() def get_posts(): cur.execute("SELECT * FROM ...
0
votes
0answers
28 views

Effeciently query small read-only data set in python

I'm working on a small web service for fetching magic card data. I'm currently testing things out on Heroku but I'm not tied there - I may just put the whole thing on some EC2 instances and call it a ...
0
votes
1answer
22 views

Web app with persistant user data stored locally

I am wanting to make a web app that allows users to input personal data , keep records and process that data. I don't really want to store each users data on my own server space , I dont want to be ...
1
vote
0answers
115 views

Handling more than 10 billion cells of data

I need to write a program in python that needs to analyze more than 100 MB of data and save it as a matrix of dimensions 100111 * 100111. What should I use? The cells need to hold integer values.
0
votes
0answers
38 views

Error while using the id of one record in another record

models.py from django.db import models import datetime class Categories(models.Model): category_name=models.CharField(max_length=200) def __unicode__(self): return ...
0
votes
0answers
23 views

python cpickle database sorting

Hi I need some help with the sortList at def player_say(ev) and def_sortDict() it doesn't work and I know i'm using many unknown variables and functions but I hope this enough to show if you have ...
1
vote
1answer
31 views

Check if db contains one or more of 1000 IDs on Google App Engine running Python

I have a app that has Facebook-integration. I am getting a list of a users facebook friends (IDs) and want to query my back end to find out which users have signed up for my service players are ...
1
vote
2answers
41 views

What is an Efficient Way to do an AND/OR Search Django-Postgres App?

In my Django app I have a Publication model and a Tag model which have a many to many relationship. Let's say I have four tags: men, women, fashion, design. I want to find all publications that have ...
0
votes
1answer
24 views

Insert list with several items into mysql database

I have a list like this: list = [('name1', 'id1', 'created_at1'),('name2', 'id2', 'created_at2'),('name3', 'id3', 'created_at3')] And I want to put it into a Mysql Database using MySQLdb that it ...
-1
votes
0answers
16 views

best crawling api for frequent and link crawling? [closed]

My project involves crawling millions of news websites(links alone) periodically and want to categorize it in the database .so i want to know which open source web crawler and database would be ...
0
votes
1answer
23 views

How to find specific data(field) in similar databases

We are using postgresql DB for our project. Each customer have their own database(all alike) i.e. We have common schemas for DB relations, for all these DBs. I would like to search a particular field ...
-1
votes
1answer
54 views

Query optimisation, finding smallest number of tables to satisfy columns? [closed]

Given a query referencing only columns, find the smallest number of tables to SELECT upon to give an accurate answer; assuming there are mechanisms in place (e.g.: ACID) which keep all data ...
0
votes
1answer
17 views

Reverse Relation Search Django Admin Interface

Is it possible to do a reverse relation search on the Django Admin interface? My Django app database schema consists of the following models: class Tag(models.Model): title = ...

1 2 3 4 5 … 91
15 30 50 per page