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
  Pandas Dataframe to Google Big Query Ecniv 1 85 Aug-21-2019, 04:56 PM
Last Post: ThomasL
  how to apply user defined function to Pandas DataFrame evelynow 3 207 Aug-20-2019, 11:35 PM
Last Post: scidam
  finding the integral of probability density function Staph 3 120 Aug-11-2019, 09:19 AM
Last Post: buran
  Create dataframe through Dictionary in pandas ift38375 2 123 Aug-11-2019, 01:09 AM
Last Post: boring_accountant
  tell exact difference between xlim() and xticks() function ift38375 3 194 Jul-12-2019, 12:04 AM
Last Post: scidam
  Finding the correct Python framework with cmake kavyasahu 0 129 Jun-26-2019, 10:04 AM
Last Post: kavyasahu
  [pandas] How to re-arrange DataFrame columns SriMekala 8 692 Jun-22-2019, 12:55 AM
Last Post: scidam
  Pandas - updating the original dataframe with sub selects Ecniv 0 155 Jun-21-2019, 02:12 PM
Last Post: Ecniv
  Market Basket Analysis: Finding Association Rules kylenater 1 253 Jun-21-2019, 03:53 AM
Last Post: scidam
  Simple String to Time within a pandas dataframe Ecniv 1 496 Jun-14-2019, 03:25 AM
Last Post: scidam

Forum Jump:


Users browsing this thread: 1 Guest(s)