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

On Mon, Jul 12, 2021 at 3:39 AM DJANGO DEVELOPER <abubakarbryar@gmail.com> wrote:

Sum thanks for your interest.

these are the screenshots of my requirements and of models.

On Mon, Jul 12, 2021 at 2:44 AM sum abiut <suabiut@gmail.com> wrote:

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.

On Fri, Jul 9, 2021 at 4:57 PM DJANGO DEVELOPER <abubakarbryar@gmail.com> wrote:

sum it is giving me error of TextField is not iterable

On Wed, Jul 7, 2021 at 5:30 AM DJANGO DEVELOPER <abubakarbryar@gmail.com> wrote:

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?

On Tue, Jul 6, 2021 at 9:40 PM sum abiut <suabiut@gmail.com> wrote:

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)

On Tue, Jul 6, 2021 at 7:09 PM lalit suthar <sutharlalit.97@gmail.com> wrote:

cool :D 

On Tuesday, 6 July 2021 at 10:25:06 UTC+5:30 abubak...@gmail.com wrote:

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

On Tue, Jul 6, 2021 at 9:21 AM Lalit Suthar <sutharl...@gmail.com> wrote:

Counter works with words also

nice one Simon Charette learned something new :) 

On Tue, 6 Jul 2021 at 07:56, DJANGO DEVELOPER <abubak...@gmail.com> wrote:

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.

On Tue, Jul 6, 2021 at 1:54 AM Simon Charette <chare...@gmail.com> wrote:

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

Le lundi 5 juillet 2021 à 13:51:48 UTC-4, abubak...@gmail.com a écrit :

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?

On Mon, Jul 5, 2021 at 5:43 PM Lalit Suthar <sutharl...@gmail.com> wrote:

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

On Mon, 5 Jul 2021 at 17:07, DJANGO DEVELOPER <abubak...@gmail.com> wrote:

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.

--
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.

--
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/CAGp2JVHuos6d4%3D-_S%3DR-q8hq48Yzf%3D-xgmPziKEA2a3DYXAzbg%40mail.gmail.com.

--
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/c77799f3-1492-459a-8187-8d62985407b6n%40googlegroups.com.

--
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/CAKPY9pnp0GG%2BwUHf68gfbMXUMV9BiY7qsR%3D_Dw1yrmsEkK6SdA%40mail.gmail.com.

--
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/CAGp2JVG4UCyNqYvhaKVAcynDEEYCSYVxG2f-E%2BdcxecHLr8qmA%40mail.gmail.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/a243e0b2-9839-410e-ae17-e1379e559509n%40googlegroups.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5HfKx%3DVuL-E%3DJop5gNTcxsnRQEXAMige7DRw6HBoNPxw%40mail.gmail.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pk-ET65FDAdj6mb9qNVcTNuH%2BjQJ5ZzjTjrj5oGXx2_NA%40mail.gmail.com.

--

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAPCf-y5LRGTjgey1hT90ewS-9HVDP3Z59qS5dGwEzEmyAQHfOQ%40mail.gmail.com.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9p%3D-moaiKxhF73%2B6z_hgqiQRmsa2Z%2B9Jd6SgAk%3DyFnXWVw%40mail.gmail.com.