python - Pandas, join row from target file based on condition -

-

i need merge row target dataframe source dataframe on fuzzy matching condition has been developed, let's call method fuzzytest. if fuzzy test returns true, want merge row target file source file when matched.

so left join target company passes fuzzytest when compared source company.

source dataframe

          source company 0           cool company 1              bigpharma 2            tod kompany 3               wallmart

target dataframe

                       target company 0                        kool company 1                           big farma 2                      todd's company 3                              c-mart 4                           supermart 5                          smallstore 6                             shoprus

hopefully after mapping through fuzzytest output be:

                       source company       target company 0                        cool company         kool company 1                           bigpharma            big farma 2                         tod kompany       todd's company 3                            wallmart                  nan

so if fuzzy logic compare 2 strings on each row, wrap function takes in column source , column target. make both columns in 1 dataframe run:

def fuzzytest(source,target):     .....     if ...:       return target     else:       return none  df['target company'] = df.apply(lambda x: fuzzytest(x['source'],x['target'])

Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more