Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 finding exact and similar matches from pandas dataframe?
#1
I have cleaned some data and created two dataframes.
Each dataframe has one column and this column contains product category names like- df1['ecommerce_cataegory_name'] & df2['my_category_name'].
These two columns are type object.
What I need to do is write a function which can-
1. find exact match between two columns and give the name
2. if no exact match found then give 3 most similar names
3. Then save above result in a csv file with column names as 'exact_match','similar_1','similar_2'and 'similar_3'.
Please suggest efficient way/solution to achieve this problem using Python 3.6.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  finding the integral of probability density function Staph 3 100 Aug-11-2019, 09:19 AM
Last Post: buran
  Create dataframe through Dictionary in pandas ift38375 2 108 Aug-11-2019, 01:09 AM
Last Post: boring_accountant
  tell exact difference between xlim() and xticks() function ift38375 3 171 Jul-12-2019, 12:04 AM
Last Post: scidam
  Finding the correct Python framework with cmake kavyasahu 0 123 Jun-26-2019, 10:04 AM
Last Post: kavyasahu
  [pandas] How to re-arrange DataFrame columns SriMekala 8 675 Jun-22-2019, 12:55 AM
Last Post: scidam
  Pandas - updating the original dataframe with sub selects Ecniv 0 150 Jun-21-2019, 02:12 PM
Last Post: Ecniv
  Market Basket Analysis: Finding Association Rules kylenater 1 244 Jun-21-2019, 03:53 AM
Last Post: scidam
  Simple String to Time within a pandas dataframe Ecniv 1 492 Jun-14-2019, 03:25 AM
Last Post: scidam
  finding index to given value from dataset gamma 3 247 May-26-2019, 06:26 PM
Last Post: heiner55
  Is there any way to properly load fixed width file into a dataframe using Pandas? vicky53 1 272 Mar-29-2019, 06:04 PM
Last Post: Larz60+

Forum Jump:


Users browsing this thread: 1 Guest(s)