I am trying to drop duplicates in my dataset and keep one of them.
I know the command
Code:
duplicates drop name modate, force
I also tried this command
Code:
by name (modate), sort: keep if _n == _N
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long funding str67 name float modate 1180043 "Equity Crowdfunding - Baanx Group" 719 3250126 "Venture Round - FeedStock Ltd" 719 676819 "Seed Round - Yimba" 719 5000000 "Venture Round - SalaryFits" 719 6500000 "Series A - ABAKA Holdings" 719 1800000 "Convertible Note - Genesis Global" 719 2818000 "Seed Round - Rebank" 719 328084 "Pre Seed Round - Bequest" 719 55757 "Grant - symmetrical.ai" 719 9431306 "Series A - Portify" 719 14048466 "Series A - FintechOS" 719 1172339 "Equity Crowdfunding - Currensea" 719 651321 "Seed Round - Visible Capital" 719 1734669 "Equity Crowdfunding - Oval Money" 719 15000000 "Debt Financing - PrimaDollar" 719 90000000 "Initial Coin Offering - Setcoin Group" 719 20000000 "Series C - Rapyd" 719 2763239 "Equity Crowdfunding - B-North" 719 20000000 "Series A - Hastee" 719 323495197 "Post-IPO Debt - Funding Circle" 719 250000 "Pre Seed Round - Clarity HQ" 719 1000000 "Seed Round - Claro Money" 719 12912373 "Seed Round - Uncapped" 719 167860846 "Series H - Zopa" 719 250000000 "Debt Financing - Hastee" 719 3411598 "Seed Round - Rossum" 718 320875 "Seed Round - Ember" 718 3229707 "Seed Round - Insurtech Gateway" 718 646389 "Seed Round - Finverity" 718 10358669 "Venture Round - Funding Xchange" 718 3000000 "Venture Round - Plum Fintech" 718 4000000 "Venture Round - Chaser" 718 5000000 "Series A - Globacap" 718 12156644 "Series A - IMMO Investment Technologies" 718 3205099 "Seed Round - Digital Debt Capital Markets" 718 4499397 "Angel Round - Chip Financial" 718 858853 "Equity Crowdfunding - The House Crowd" 718 1617704 "Seed Round - Diaspora" 718 77631213 "Series A - Pollinate Networks" 717 15526243 "Series A - Freetrade" 717 6450473 "Debt Financing - TotallyMoney" 717 6450473 "Seed Round - M∙QUBE" 717 4900000 "Seed Round - Koyo" 717 655000000 "Venture Round - Greensill Capital" 717 3206748 "Series A - Oval Money" 717 38761292 "Venture Round - Starling Bank" 717 688004 "Series A - 3S Money" 717 4550349 "Equity Crowdfunding - ANNA : Absolutely No Nonsense Admin" 717 2572910 "Seed Round - Proportunity" 717 854838 "Seed Round - Thirdfort" 717 74010023 "Series B - Tide" 717 52500 "Seed Round - KodyPay" 717 4619479 "Equity Crowdfunding - Chip Financial" 717 688338 "Seed Round - Armadillo Financial Technologies" 717 100000000 "Series C - Rapyd" 717 2500000 "Seed Round - CRED Investments" 717 4915998 "Series A - DeadHappy" 716 44383075 "Series C - Moneyfarm" 716 18000000 "Series A - FIDEL API" 716 1955000 "Seed Round - skew." 716 4000000 "Venture Round - Digital Fineprint (DFP)" 716 4369849 "Series A - MishiPay" 716 2000000 "Seed Round - Bottlepay" 716 3073094 "Equity Crowdfunding - Plum Fintech" 716 4000000 "Venture Round - Cazana" 716 1252315 "Seed Round - Tumelo" 716 12425663 "Series B - Netwealth" 716 2485133 "Seed Round - TreasurySpring" 716 1600000 "Pre Seed Round - Kudimoney" 716 1233551 "Seed Round - Storm2" 716 1938730 "Equity Crowdfunding - Creditspring" 716 1235756 "Seed Round - Finance Unlocked" 716 1600000 "Pre Seed Round - Kuda Bank" 716 166000 "Seed Round - Equipment Connect" 716 135803643 "Venture Round - Sonovate" 716 1235 "Pre Seed Round - DarQube" 716 37692 "Equity Crowdfunding - Squirrel" 716 8600000 "Series A - PrimaryBid" 716 10000000 "Series A - Railsbank" 716 7195358 "Equity Crowdfunding - Curve" 716 49377 "Grant - Zlick" 716 1816225 "Equity Crowdfunding - goHenry" 716 542925 "Pre Seed Round - ResonanceX" 716 425550 "Pre Seed Round - Appital" 716 3700000 "Venture Round - Project Imagine" 716 1459027 "Seed Round - Pomelo Pay" 716 121586 "Pre Seed Round - HELPFUL" 716 2614188 "Seed Round - Penfold" 715 250000 "Pre Seed Round - Claro Money" 715 100997 "Seed Round - AreOne.com" 715 303975 "Pre Seed Round - Elfin Market" 715 547156 "Seed Round - Whitehall Finance" 715 24182 "Pre Seed Round - Bond180" 715 400000 "Seed Round - wamo" 715 10000000 "Venture Round - VeganNation" 715 15000000 "Venture Round - LendInvest" 715 904508 "Seed Round - Knoma" 715 12060108 "Grant - iwoca" 715 11000000 "Series A - flatfair" 715 12060108 "Grant - Currencycloud" 715 end format %tm modate
0 Response to Drop Duplicates comparing two variables and keep one of them
Post a Comment