Loading csv data in database

[Muhammad Asim Khaskheli]

Hi,

I wanted to ask how to load CSV data into the model. What steps do we have to follow?

I have made this function but how exactly to run this code because, python manage.py load data won't work.

def import_data():
with open('sample-dataset.csv') as f:
reader = csv.reader(f)
for row in reader:
if row[0] != 'user_id':
_, created = Funnel.objects.get_or_create(
user_id=row[0],
event=row[1],
timestamp=row[2],
session_id=row[3]
)

Now, how to run this script?

[Ryan Nowakowski]

Typically you would write a custom management command for this kind of thing:

https://docs.djangoproject.com/en/3.2/howto/custom-management-commands/

[Nauman Khan gori]

you may use pandas for this 

you can use it as follows:-

first install it

if not using python from anaconda environment!

pip install pandas

import pandas as pd

reader=pd.read_csv("sample-dataset.csv")

reader.head(3) # for viewing top 3 rows.

hope this may help you

 -)-)

[Derek]

Someone has an example of doing just this:

https://arshovon.com/blog/django-custom-command/

[Amitesh Sahay]

try the below way. Its simple

Writing custom django-admin commands | Django documentation | Django

Writing custom django-admin commands | Django documentation | Django

Regards,

Amitesh

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit

https://groups.google.com/d/msgid/django-users/137aee79-07e6-40e1-badd-671ae3b0c87cn%40googlegroups.com

.