Rating Pyramid (database subset statistics)

[Mattias Carlsson]

Having rated a bunch of images, I would like to see a rating statistics, e.g. a rating pyramid as presented at http://docs.kde.org/development/en/extragear-graphics/digikam/dam.html. Now, I know it would be possible to choose advanced filter for each of the rating and picture subset, noting the number of item for each rating in e.g. Spreadsheet and then compare to an "optimal" rating pyramid, but this would be inflexible to use for different subsets.

It would be slick to have a function where you can select any subset of pictures and choose to get a "rating pyramid" displaying the rating ratio for the selection. A graphic pyramid could simplify the viewing of the skewing, but just numbers in a table would suffice together with the recommendation from e.g. the posted link and maybe also a "diff ratio" for each rating to highlight the skewing of the rating.

Is there some existing way to do this, or is this a feature that anyone else also would find useful?

Regards,

Mattias

---

Hotmail: Powerful Free email with security by Microsoft. Get it now.
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[pshute]

It sounds like the sort of thing that would be fairly simple if you queried the database directly with SQL commands. Grouping by rating could give you the counts for each rating with one query, if that's what you mean, grouped by year, etc, if necessary. Does anyone know how to access the database directly? Is there a recommended front end?

I would have simply called it the ratings counts. It's only a pyramid if you get more bad shots than good shots, which is true for most of us, of course.


--------------------------
Sent using BlackBerry

---

From: Mattias Carlsson
To: [hidden email]
Sent: Sun Apr 11 23:28:38 2010
Subject: [Digikam-users] Rating Pyramid (database subset statistics)

Having rated a bunch of images, I would like to see a rating statistics, e.g. a rating pyramid as presented at http://docs.kde.org/development/en/extragear-graphics/digikam/dam.html. Now, I know it would be possible to choose advanced filter for each of the rating and picture subset, noting the number of item for each rating in e.g. Spreadsheet and then compare to an "optimal" rating pyramid, but this would be inflexible to use for different subsets.

It would be slick to have a function where you can select any subset of pictures and choose to get a "rating pyramid" displaying the rating ratio for the selection. A graphic pyramid could simplify the viewing of the skewing, but just numbers in a table would suffice together with the recommendation from e.g. the posted link and maybe also a "diff ratio" for each rating to highlight the skewing of the rating.

Is there some existing way to do this, or is this a feature that anyone else also would find useful?

Regards,

Mattias

---

Hotmail: Powerful Free email with security by Microsoft. Get it now.
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johnny]

 Peter Shute <[hidden email]> writes:

> From: Mattias Carlsson
>
>> Having rated a bunch of images, I would like to see a rating statistics, e.g. a
>> rating pyramid as presented at http://docs.kde.org/development/en/
>> extragear-graphics/digikam/dam.html. Now, I know it would be possible to choose
>> advanced filter for each of the rating and picture subset, noting the number of
>> item for each rating in e.g. Spreadsheet and then compare to an "optimal"
>> rating pyramid, but this would be inflexible to use for different subsets.
>>
>> It would be slick to have a function where you can select any subset of
>> pictures and choose to get a "rating pyramid" displaying the rating ratio for
>> the selection. A graphic pyramid could simplify the viewing of the skewing, but
>> just numbers in a table would suffice together with the recommendation from
>> e.g. the posted link and maybe also a "diff ratio" for each rating to highlight
>> the skewing of the rating.
>>
>> Is there some existing way to do this, or is this a feature that anyone else
>> also would find useful?
>>
> It sounds like the sort of thing that would be fairly simple if you queried the
> database directly with SQL commands. Grouping by rating could give you the
> counts for each rating with one query, if that's what you mean, grouped by
> year, etc, if necessary. Does anyone know how to access the database directly?
> Is there a recommended front end?
>
> I would have simply called it the ratings counts. It's only a pyramid if you
> get more bad shots than good shots, which is true for most of us, of course.

Picking up an old thread as this was a good challenge while learning
Python coding! The attached Python script creates a rating pyramid
for the entire database. Currently, it creates two pyramids, one
with /all/ ratings and one with only 1-5 ratings (to avoid a wide base
that makes the top ridiculously small if one has many lowly rated
images).

Admittedly, this is not the greatest and most flexible thing, but a
concept if someone is inclined to build on it further, in particular it
would be great to run only for subalbums or other subsets of the DB.

This was written using Python 2.7.1. To use, that needs be installed as
well as the pyton modules sqlite and tkinter. The path to the digikam database
must be supplied as a command line argument.

./ratingpyramid.py /your/path/to/digikam_images.db

The necessary python modules can be installed by (on Fedora)
: yum install python python-sqlite2

Also, don't forget to make the script executable:
: chmod 755 ratingpyramid.py



Example view:



Cheers!
--
Johnny

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Rinus]

Hi Johnny,

Nice work, It shows good how hard it is to make a level 5 rated picture.

As this is a user list, supposed to be photographers rather than programmers, there might be some more guiding needed for us to be able to play with it.
Or if it not is meant for us to play with you should maybe post it in the devellopers list, although I would rather see the programmers work on the core of digikam instead of implementing such fancy stuff.

Regards,
Rinus


Op 01-09-11 22:28, Johnny schreef:

Picking up an old thread as this was a good challenge while learning
Python coding! The attached Python script creates a rating pyramid
for the entire database. Currently, it creates two pyramids, one
with /all/ ratings and one with only 1-5 ratings (to avoid a wide base
that makes the top ridiculously small if one has many lowly rated
images).

Admittedly, this is not the greatest and most flexible thing, but a
concept if someone is inclined to build on it further, in particular it
would be great to run only for subalbums or other subsets of the DB.

This was written using Python 2.7.1. To use, that needs be installed as
well as the pyton modules sqlite and tkinter. The path to the digikam database
must be supplied as a command line argument.

./ratingpyramid.py /your/path/to/digikam_images.db

The necessary python modules can be installed by (on Fedora)
: yum install python python-sqlite2 

Also, don't forget to make the script executable:
: chmod 755 ratingpyramid.py

Example view:

Cheers!

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johnny]

sleepless <[hidden email]> writes:

> As this is a user list, supposed to be photographers rather than programmers,
> there might be some more guiding needed for us to be able to play with
> it.
You need to have Python 2 installed and the mentioned Python modules
(sqlite, tkinter). I posted tentative instructions for Fedora, as this
is the platform I use and am familiar with. If you have this
installed, just :

1) download the script
2) make it executable (as superuser)
   su
   [type your su password]
   chmod 755 ./ratingpyramid.py
   exit
3) run the script from the command line
   ./ratingpyramid.py /your/path/to/digikam_images.db
   (Change the path to the full path to /your/ digikam db however!)

> Or if it not is meant for us to play with you should maybe post it in the
> devellopers list, although I would rather see the programmers work on the core
> of digikam instead of implementing such fancy stuff.
I guess it is individual whether it is "fancy stuff" or an efficient
tool in your digital asset management workflow, as introduced in the
digikam handbook [1] which inspired the development. It is certainly a
worthwhile read, whether you choose to follow it or not!

> Op 01-09-11 22:28, Johnny schreef:
>
>     Picking up an old thread as this was a good challenge while learning
>     Python coding! The attached Python script creates a rating pyramid
>     for the entire database. Currently, it creates two pyramids, one
>     with /all/ ratings and one with only 1-5 ratings (to avoid a wide base
>     that makes the top ridiculously small if one has many lowly rated
>     images).
>    
>     Admittedly, this is not the greatest and most flexible thing, but a
>     concept if someone is inclined to build on it further, in particular it
>     would be great to run only for subalbums or other subsets of the DB.
>    
>     This was written using Python 2.7.1. To use, that needs be installed as
>     well as the pyton modules sqlite and tkinter. The path to the digikam database
>     must be supplied as a command line argument.
>    
>     ./ratingpyramid.py /your/path/to/digikam_images.db
>    
>     The necessary python modules can be installed by (on Fedora)
>     : yum install python python-sqlite2
>    
>     Also, don't forget to make the script executable:
>     : chmod 755 ratingpyramid.py
>
>     Example view:
>
>     Cheers!
>

Footnotes:
[1] http://docs.kde.org/development/en/extragear-graphics/digikam/dam.html

--
Johnny
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Rinus]

Thanks for the explanation. I am certainly going to experiment and quite
surprised that code can be executed without compiling and linking.
Is it recommended to play with a copy of the db, or can it not be hurt
in anyway?
Rinus
Op 02-09-11 18:06, Johnny schreef:

> sleepless<[hidden email]>  writes:
>
>> As this is a user list, supposed to be photographers rather than programmers,
>> there might be some more guiding needed for us to be able to play with
>> it.
> You need to have Python 2 installed and the mentioned Python modules
> (sqlite, tkinter). I posted tentative instructions for Fedora, as this
> is the platform I use and am familiar with. If you have this
> installed, just :
>
> 1) download the script
> 2) make it executable (as superuser)
>     su
>     [type your su password]
>     chmod 755 ./ratingpyramid.py
>     exit
> 3) run the script from the command line
>     ./ratingpyramid.py /your/path/to/digikam_images.db
>     (Change the path to the full path to /your/ digikam db however!)
>
>> Or if it not is meant for us to play with you should maybe post it in the
>> devellopers list, although I would rather see the programmers work on the core
>> of digikam instead of implementing such fancy stuff.
> I guess it is individual whether it is "fancy stuff" or an efficient
> tool in your digital asset management

Of course, I was speaking for myself, and fancy stuff was in no way ment
to be offencive.

> workflow, as introduced in the
> digikam handbook [1] which inspired the development. It is certainly a
> worthwhile read, whether you choose to follow it or not!
>
>> Op 01-09-11 22:28, Johnny schreef:
>>
>>      Picking up an old thread as this was a good challenge while learning
>>      Python coding! The attached Python script creates a rating pyramid
>>      for the entire database. Currently, it creates two pyramids, one
>>      with /all/ ratings and one with only 1-5 ratings (to avoid a wide base
>>      that makes the top ridiculously small if one has many lowly rated
>>      images).
>>
>>      Admittedly, this is not the greatest and most flexible thing, but a
>>      concept if someone is inclined to build on it further, in particular it
>>      would be great to run only for subalbums or other subsets of the DB.
>>
>>      This was written using Python 2.7.1. To use, that needs be installed as
>>      well as the pyton modules sqlite and tkinter. The path to the digikam database
>>      must be supplied as a command line argument.
>>
>>      ./ratingpyramid.py /your/path/to/digikam_images.db
>>
>>      The necessary python modules can be installed by (on Fedora)
>>      : yum install python python-sqlite2
>>
>>      Also, don't forget to make the script executable:
>>      : chmod 755 ratingpyramid.py
>>
>>      Example view:
>>
>>      Cheers!
>>
> Footnotes:
> [1] http://docs.kde.org/development/en/extragear-graphics/digikam/dam.html
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johnny]

sleepless <[hidden email]> writes:
> Thanks for the explanation. I am certainly going to experiment and
> quite surprised that code can be executed without compiling and
> linking.
I'll try to help where I can, let me know any questions.
> Is it recommended to play with a copy of the db, or can it not be hurt
> in anyway?
As always, playing with a copy is recommended, but as the script is only
accessing data from the database, there should be no risk to use the
"real" database.
--
Johnny
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users