• 0

How would you sort 20000 unrelated pictures?


Question

I've accrued around 20000 images of internet randomness, and their disparate file names have finally triggered my OCD. I'm at a complete loss at a practical structure and method for batch sorting and renaming them. My lazy inclination is to rename by creation date, but after meeting people who sort their porn by color and emotion (don't ask) and others with too much time sorting their image collection by subject (i.e. img \bears \ bear tongue \beartonguelong.jpg ), I feel like I should... do better.

If no exiting program can automate this, I think I'm going to have to write or try to convince my developer friend to write a script to determine the RGB value of each picture and rename them as RGB scales so I can search them by rough color ranges. i.e. R24G10B01.jpg for all images with R240-249, G100-109, B 10-19. Maybe too much work for something like this. Either way, I'm just polling to see if there's any organization structures for random pictures I'm not thinking of.

Recommended Posts

  • 0

Is there some sort of metadata available that would tell you where it was downloaded from?

I'm sure something like this exists somewhere, but I can't remember on which operating system and which details were available.

If that is the case, you would be able to arrange it to some degree based on where you got the image from.

  • 0

Obviously you need to put your vacation time in with work, then start looking at the photos one at a time, and moving them into catagories(such as funny, gross, sexy, etc), then naming them based on the catagory.

That or just delete them, because really, are you going to look at them again?

  • 0

Ask yourself if you really need them or are unnecessarily hoarding them.

The only way to sort them if you really need them is the painful way - sort by subject, manually.

If not select all and delete - probably what I would do - and problem solved.

  • 0

It's a good question; what do you even need them for?

If they're just sat there and you have no way of finding anything, surely you have no need for them?

Whenever I've downloaded images that I want to keep (mainly 'good' design and stuff) I've simply sorted them by the source and date. I've done it like this because I thought I'd actually go back to them at some point, and I do, and doing so is a pleasure :)

  • 0

20,000?

Do 100 a day, and 5 1/2 years from now you'll be done!

Seriously though, if I had that many pictures I would just accept the order that it was in rather than trying to change it.

Where did you learn to do maths lol

100 a day for 20k would be 200 days lol

  • 0

Just use something like Picasa, go through and batch tag all the important pictures. Like Holiday, Florida, Dog, Cat, Sister, Party etc. That way all the ones you will want to find can be done easily. I wouldn't worry about actual image path locations as images can be categorised many times. Like Funny, memes, rage.

  • 0

It's a good question; what do you even need them for?

If they're just sat there and you have no way of finding anything, surely you have no need for them?

Whenever I've downloaded images that I want to keep (mainly 'good' design and stuff) I've simply sorted them by the source and date. I've done it like this because I thought I'd actually go back to them at some point, and I do, and doing so is a pleasure :)

They're 80% design or photography stuff from various genres and the rest probably an assortment of cats and gifs. The images are saved automatically from starred google reader items using IFTTT with site title in the file name, but that's pretty redundant with reverse image search which is why I think sorting by color would do the trick. I go through them pretty often too, maybe I have to con some interns into sorting them, but there's way too much questionable stuff mixed in.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Microsoft adds reusable skills and finance data connectors to Copilot in Excel by Karthik Mudaliar Microsoft is giving Copilot in Excel a collection of new features aimed squarely at finance teams. The update introduces reusable instructions for common tasks, connections to services such as FactSet and Morningstar, and a better way to review what Copilot intends to do before it starts changing a workbook. The most interesting addition is 'Skills' finally coming to Copilot in Excel. Skills let companies teach Copilot how to handle a recurring process, so employees do not need to write the same detailed prompt every month. Users can create skills that can specify the steps Copilot should follow, along with the required layout, formulas, and formatting. Microsoft says users can create their own skills by saving a SKILL.md file in OneDrive. The file is written using Markdown and tells Copilot when and how to perform the task. Once it is available, a user can select the skill in the Copilot pane or mention it in a prompt using the @ symbol. There is also a library of prebuilt finance skills for customers who do not want to create their own. Microsoft plans to let developers distribute additional skills through the Microsoft Marketplace and the Microsoft 365 Admin Center, with LSEG, Ramp, Rogo, samaya.ai, Velixo, and Vena among the first partners involved. The company says that it is also expanding the external data that Copilot can access from inside Excel. New connectors are being added for CB Insights, Daloopa, FactSet, Morningstar, PitchBook, and S&P Global data through technology developed by Kensho. There is a catch, however. Accessing these services may require a separate subscription from the relevant data provider, so a Microsoft 365 Copilot licence will not necessarily unlock all of them. FactSet is also only available in preview for now, with general availability planned for July. Microsoft is also trying to make Copilot’s workbook edits easier to inspect. Users can switch to a planning mode that shows which sheets, cell ranges, formulas, and assumptions Copilot intends to work with before it begins making changes. Once the work is complete, the Show Changes pane can distinguish edits made by Copilot from those made by human collaborators. The update continues Microsoft’s push to turn Excel Copilot from a chatbot into an agent that can carry out longer tasks. The company previously added an Agent Mode capable of planning and completing multi-step Excel work. Microsoft also recently acquired financial AI startup Fintool, another indication that finance is becoming a key target for its Excel AI strategy. Prebuilt skills, personalization, workbook rules, external connectors, planning mode, and Copilot attribution in Show Changes are generally available to Microsoft 365 Copilot customers using Excel on the web, Windows, and macOS. Custom skills are initially available to Microsoft 365 Insiders on Windows and Mac starting today. Microsoft plans to make them generally available across Windows, Mac, and the web over the next month. Partner-built skills are expected during the third quarter of the year. Availability may still differ depending on region and licensing.
    • Exactly. They serve different (although related) purposes.
    • Do not enter the code under any circumstances, or you will be sorry. It's definitely and most likely a hacking attempt.  That happened to me a couple of years ago, and I kept receiving those prompts for months. It's simply the attacker trying to get you tired of the constant requests, so you just give up and enter the code, so they can log in to your account. 
  • Recent Achievements

    • First Post
      kinowa earned a badge
      First Post
    • Rookie
      krychek57 went up a rank
      Rookie
    • Grand Master
      Jaybonaut went up a rank
      Grand Master
    • One Year In
      Philsl earned a badge
      One Year In
    • Dedicated
      Scoobystu earned a badge
      Dedicated
  • Popular Contributors

    1. 1
      +primortal
      438
    2. 2
      +Edouard
      169
    3. 3
      PsYcHoKiLLa
      134
    4. 4
      Xenon
      77
    5. 5
      Michael Scrip
      75
  • Tell a friend

    Love Neowin? Tell a friend!