Python Forum
Filter only highest version of list with alpanumeric names
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filter only highest version of list with alpanumeric names
#1
Hello everyone,

I've have a CSV file with the following documentnames with version (example):

name1.A01
name1.A02
name1.A03
name2.A01
name2.A02
name2.A03
name2.A04
name3.A01
name3.A02
name3.A04
(name3.A03 is not in the list by purpose)

New file should contain:

name1.A03
name2.A04
name3.A04

Anyone an idea how to solve?
Reply


Messages In This Thread
Filter only highest version of list with alpanumeric names - by Haasje - Aug-30-2019, 06:58 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How can i get the top smallest and top highest value for each row in pandas? mahmoudr899 4 1,366 Jun-03-2024, 07:54 PM
Last Post: marythodge4
  Read directory listing of files and parse out the highest number? cubangt 5 5,119 Sep-28-2022, 10:15 PM
Last Post: Larz60+
  Find the highest value of a list Menthix 4 2,819 Oct-29-2021, 02:32 PM
Last Post: Menthix
  Sorting list of names using a lambda (PyBite #5) Drone4four 2 3,517 Oct-16-2020, 07:30 PM
Last Post: ndc85430
  Topic: “Filter numbers with a list comprehension” (PyBite #107) Drone4four 4 3,273 Jun-11-2020, 08:31 PM
Last Post: Drone4four
  List comprehension. Shor for loop version dervast 1 2,133 Dec-11-2019, 12:34 PM
Last Post: perfringo
  Details of attachment files in a msg file such as file names save into a python list klllmmm 2 7,010 Nov-12-2019, 05:59 AM
Last Post: klllmmm
  How to combine file names into a list from multiple directories? python_newbie09 3 7,228 Jul-09-2019, 07:38 PM
Last Post: python_newbie09
  Filter to List and/or Tuple conversion vindo 3 3,608 May-18-2019, 05:40 AM
Last Post: perfringo
  Getting the key for the highest value in a dict - how does this code work? rogfrich 4 4,247 Nov-27-2018, 07:05 PM
Last Post: rogfrich

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020