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