error if primary_key is not int() about django-pandas

[abdeltif-b]

I have the same issue when the foreign-key in a model is a string. Any workaround for this?

[bartpijn]

I worked around it by specifying the cols.

[krishnakafle]

I have face similar issue

invalid literal for int() with base 10: 'bk-dw-02'

Specifying of columns doesn't help me either.

qs = GwMonitoringKobo.objects.all()
df = read_frame(qs, fieldnames=['date', 'district', 'latitude','longitude','altitude','precision','well_type','measurement_point_cm', 'measurement_of_wet_point_on_tape_in_m_field',
                 'gw_level_from_mp','mp_in_m','gw_level', 'fid','well_num'])

[sundyloveme]

why I am ok??
I am configuration:
Django 2.2
numpy 1.21.5
pandas 1.3.5
pip 21.1.2
python-dateutil 2.8.2
pytz 2021.3
semver 2.13.0
setuptools 57.0.0
six 1.16.0
sqlparse 0.4.2
wheel 0.36.2

[TheAbhilash23]

Can you tell why you have set your entity relationship as

class Testing1(models.Model):
symbol = models.CharField('Ticker', max_length=32, primary_key=True)
tf = models.CharField('timeframe', max_length=1)

class Testing2(models.Model):
symbol = models.ForeignKey(Testing1, on_delete=models.CASCADE)
price = models.CharField('price', max_length=1)

When I setup the models I use Model Class as Foreign key, for instance

class Testing1(models.Model):
symbol = models.CharField('Ticker', max_length=32, primary_key=True)
tf = models.CharField('timeframe', max_length=1)

class Testing2(models.Model):
Testing1 = models.ForeignKey(Testing1, on_delete=models.CASCADE, related_name='Testing1Symbols')
price = models.CharField('price', max_length=1)

[tlk3]

Why would you code it this way? Never seen this type of model / ForeignKey relationship. It's not logical.