{"id":14997,"date":"2023-01-01T08:23:40","date_gmt":"2023-01-01T07:23:40","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/literature-review-how-to-filter-out-redundant-search-results-from-similar-search-iterations\/"},"modified":"2023-01-01T08:23:40","modified_gmt":"2023-01-01T07:23:40","slug":"literature-review-how-to-filter-out-redundant-search-results-from-similar-search-iterations","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/literature-review-how-to-filter-out-redundant-search-results-from-similar-search-iterations\/","title":{"rendered":"Literature Review &#8211; How To Filter Out Redundant Search Results From Similar Search Iterations?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hey all, I&#8217;ve got sort of an unusual research question. Basically, I&#8217;d like to perform a comprehensive review of all the literature of a particular topic. To do this, I&#8217;d like to use combinations of search terms. For example, I&#8217;d conduct a search using terms &#8220;A&#8221; and &#8220;B&#8221;, then I&#8217;d conduct another search using terms &#8220;A&#8221; and &#8220;C&#8221;, then again using &#8220;A&#8221; and &#8220;D&#8221;, etc. The problem with this is that there&#8217;s a decent amount of overlap of search results among these different combinations and there are thousands of search results for each combination so I want to minimize redundancy as much as possible in order to save time. Is there a way for me to conduct an initial search (e.g., A + B) and then conduct each subsequent search (A + C, A + D, etc.) that will only show search results that are NOT included in the initial A + B search?<\/p>\n<p>I&#8217;m using OVID Medline as the search database, but I&#8217;d be open to any general workaround solutions as well. From my limited knowledge on a possible solution, I was wondering if it&#8217;s possible to export all the search results, copy them as a list into a column within Excel, and then use the Excel function that can highlight duplicate values. This method would allow me to avoid redundant search results from each search iteration. This isn&#8217;t an elegant solution imo, but I imagined a possible solution like this. The most ideal solution would be for the database to filter out redundant search results for me automatically.<\/p>\n<p>I can explain or clarify the problem further if that&#8217;s helpful. Thank you for any help or suggestions with this problem!!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/pantaloonsss\"> \/u\/pantaloonsss <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/122crgp\/literature_review_how_to_filter_out_redundant\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/122crgp\/literature_review_how_to_filter_out_redundant\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-14997 jlk' href='javascript:void(0)' data-task='like' data-post_id='14997' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-14997 lc'>0<\/span><\/a><\/div><\/div> <div class='status-14997 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hey all, I&#8217;ve got sort of an unusual research question. Basically, I&#8217;d like to perform a comprehensive&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-14997","post","type-post","status-publish","format-standard","hentry","category-othernonsense","wpcat-7-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/14997","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=14997"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/14997\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=14997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=14997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=14997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}