So I found this
It does exactly what I'm looking for, but I need to edit the file in place without creating another file. I've checked the man page and sadly I can't really find a solution.
I've browsed the suggested similar questions and none of them specifically address what I'm trying to do.
I have tried awk -f',' '!seen[$4]++' ~/Desktop/info.csv > ~/Desktop/info.csv
but when it overwrites, the file is completely blank.
TIA for any help.