@echo off
(for /f "tokens=1,2 delims=," %%i in (1.csv) do (
     if defined _%%j (
        if not defined #%%i echo,[0-9]*,%%j,
    )
    set #%%i=true
    set _%%j=true
))>log
(echo,batch,source,time,lat
findstr /b /g:log 1.csv)>temp
type temp>1.csv
del log temp
复制代码

batch,source,time,lat
12,9001,0.024632866,0.905915485
1,9002,0.782254972,0.457675474
12,9001,0.149382191,0.533533094
10,9001,0.522246607,0.0429526
12,9001,0.355786377,0.995325435
12,9001,0.416155121,0.436677966
10,9001,0.122666718,0.401502167
10,9001,0.001995224,0.132484873
10,9001,0.578341874,0.848645374
1,9002,0.624128442,0.995400678
10,9001,0.057870604,0.011974136
1,9002,0.195745245,0.441528805
12,9001,0.392076483,0.381371589
复制代码

set csv=1.csv
echo off
set n=0
cd /d "%~dp0%"
setlocal enabledelayedexpansion
del temp.tmp
for /f "skip=1 tokens=2 delims=," %%i in (%csv%) do (
	set exist=0
	for /f "delims=" %%n in (temp.tmp) do if "%%n"=="%%i" set exist=1
	if !exist!==0 echo %%i>> temp.tmp
	)

for /f "delims=" %%n in (temp.tmp) do (
	set delete=1
	set pre=
	for /f "skip=2 tokens=1 delims=," %%i in ('find ",%%n," %csv%') do (
		if not defined pre set pre=%%i
		if not "%%i"=="!pre!" set delete=0
		)
	if !delete!==1 call :delcsv %%n
	)

pause
del temp.tmp
exit

:delcsv
echo off
(for /f "skip=2 delims=" %%d in ('find /v ",%1," %csv%') do echo %%d)>> newcsv.csv
del %csv%
ren newcsv.csv %csv%
goto :eof
复制代码