counting the same words within a song added by a user using Django

[DJANGO DEVELOPER]

Hi there.

I am developing a project based on adding songs to the user's library and to the home page.

other users can also purchase the songs like wise people do shopping on eCommerce stores.

Problem:(Question)

The problem that I want to discuss here is that when a user adds a sing through django forms, and now that song is added to the user's personal library.

now what I want to do is :

When the lyrics of a song are added as a record to the "Song" table, the individual words in that song should be added to a 2nd table with their frequency of usage within that song (so the words need to be counted and a signal needs to be created).

Also, when a user adds the song to his/her personal library, all of the words from the song and their frequencies within that song should be added to another table and associated with that user.

how to count same word within a song? 

can anyone help me here?

your help would be appreciated.

[Lalit Suthar]

https://www.guru99.com/python-counter-collections-example.html
Counter can be helpful for this situation

--
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/bc7bc37b-6f26-465c-b330-d275ab86b76an%40googlegroups.com.

[DJANGO DEVELOPER]

Thank you Lalit bhai.

it seems to be a solution.

but what if I want to get the result for each single word rather than single letter?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGp2JVHuos6d4%3D-_S%3DR-q8hq48Yzf%3D-xgmPziKEA2a3DYXAzbg%40mail.gmail.com.

[Simon Charette]

If you're using a PostgreSQL you might want to look at using a tsvector column instead which will ignore stop words (the, or, of, ...) and map lexemes to their number of occurrence and position in the lyrics[0]. Assuming you were to index this column you'd be able to efficiently query it for existence of a particular lexeme or multiple of them.

You could then a union of all a user's song lyrics tsvector and even apply weights based on their listening frequency or their favorite songs.

Cheers,

Simon

[0] https://stackoverflow.com/questions/25445670/retrieving-position-and-number-of-lexem-occurrences-from-tsvector

[DJANGO DEVELOPER]

thanks Simon but I am not using postgresql. I am using sqlite3 database. so I want a global solution, that work in all the databases.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/c77799f3-1492-459a-8187-8d62985407b6n%40googlegroups.com.

[Lalit Suthar]

Counter works with words also

nice one Simon Charette learned something new :) 

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pnp0GG%2BwUHf68gfbMXUMV9BiY7qsR%3D_Dw1yrmsEkK6SdA%40mail.gmail.com.

[DJANGO DEVELOPER]

I found this as well. and I think  I want the result this way.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGp2JVG4UCyNqYvhaKVAcynDEEYCSYVxG2f-E%2BdcxecHLr8qmA%40mail.gmail.com.

[lalit suthar]

cool :D 

[sum abiut]

You can to something like this

def count_songs(request):

#get the field that you want to count the words in it

field_name = model._meta.get_field('your_field)

word_count =Counter(field_name)

for key, value in word_count.items():

      key = key

      value=value

context={

'key':key,

'value':value,
}

return render(request, 'template.html', context)

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a243e0b2-9839-410e-ae17-e1379e559509n%40googlegroups.com.

[DJANGO DEVELOPER]

so will it run smoothly?

I mean there is no filter function there so will it filter a specific field and will give me count for the words?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5HfKx%3DVuL-E%3DJop5gNTcxsnRQEXAMige7DRw6HBoNPxw%40mail.gmail.com.

[DJANGO DEVELOPER]

sum it is giving me error of TextField is not iterable

[DJANGO DEVELOPER]

https://stackoverflow.com/questions/41689274/split-multiple-selections-into-separate-records-in-a-django-model

I also want the same result as it is mentioned here in the stackoverflow question

[sum abiut]

I might not fully understand your question. Can you show me what you have done? show us your models and what you want to achieve.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pk-ET65FDAdj6mb9qNVcTNuH%2BjQJ5ZzjTjrj5oGXx2_NA%40mail.gmail.com.

--

[DJANGO DEVELOPER]

Sum thanks for your interest.

these are the screenshots of my requirements and of models.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5LRGTjgey1hT90ewS-9HVDP3Z59qS5dGwEzEmyAQHfOQ%40mail.gmail.com.

[DJANGO DEVELOPER]

[RaviKiran Kk]

We are looking for django developer

Plz contact 6309620745

--