Look at 'difflib.SequenceMatcher' (https://docs.python.org/3/library/difflib.html#difflib.SequenceMatcher) in the Python ecosystem. Your favorite language may have something similar. Essentially, you are need to compute 'similarity' between two strings.
If your prefix e.g. AltCoin in "AlCoin Trader 20220" and "AltCoin 202132" are fixed and have no typos, you can solve it by regular expressions (https://docs.python.org/3/library/re.html). Regular Expressions (regex) are pretty well-supported even in GUI-based office suites. -- Dilawar On Friday, February 18, 2022 at 3:24:05 PM UTC+5:30 [email protected] wrote: > Hi all, > > I have a data frame that includes yearweek (week of the year), > entity_name, and deposit_volume_btc (volume for each entity based on week > of the year). How I can merge the first and last deposit_volume for each > entity name? > > For example: > [image: Screenshot 2022-02-14 at 4.24.57 PM.png] > - AAX 20220 deposit_volume should be merged with AAX 202152 and similarly, > AltCoin Trader 20220 deposit volume should be merged with AltCoin 202132. > -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/datameet/37419b29-1ead-4acc-84cd-11a07606357dn%40googlegroups.com.
