{"id":40237,"date":"2026-04-07T17:47:23","date_gmt":"2026-04-07T15:47:23","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/need-to-tag-30k-vendors-as-it-vs-non-it\/"},"modified":"2026-04-07T17:47:23","modified_gmt":"2026-04-07T15:47:23","slug":"need-to-tag-30k-vendors-as-it-vs-non-it","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/need-to-tag-30k-vendors-as-it-vs-non-it\/","title":{"rendered":"Need To Tag ~ 30k Vendors As IT Vs Non-IT"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi everyone,<\/p>\n<p>I have a large xlsx vendor master list (~30k vendors).<\/p>\n<p>Goal:<\/p>\n<p>Add ONE column: &#8220;IT_Relevant&#8221; with values Yes \/ No.<\/p>\n<p>Definition:<\/p>\n<p>Yes = vendor provides software, hardware, IT services, consulting, cloud, infrastructure, etc.<\/p>\n<p>No = clearly non\u2011IT (energy, hotel, law firm, logistics, etc.).<\/p>\n<p>Accuracy does NOT need to be perfect \u2013 this is a first\u2011pass filter for sourcing analysis.<\/p>\n<p>Question:<\/p>\n<p>What is a practical way to do this at scale?<\/p>\n<p>Can it be done easily? Basically, the companies should be researched (web) to decide if it is IT relevant or not. ChatGPT cannot handle that much data.<\/p>\n<p>Thank you for your help.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/Grindelwaldt\"> \/u\/Grindelwaldt <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1seyi8m\/need_to_tag_30k_vendors_as_it_vs_nonit\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1seyi8m\/need_to_tag_30k_vendors_as_it_vs_nonit\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-40237 jlk' href='javascript:void(0)' data-task='like' data-post_id='40237' 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-40237 lc'>0<\/span><\/a><\/div><\/div> <div class='status-40237 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi everyone, I have a large xlsx vendor master list (~30k vendors). Goal: Add ONE column: &#8220;IT_Relevant&#8221;&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-40237","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40237","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"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=40237"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40237\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=40237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=40237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=40237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}