manipulating the imdb.csv data base.

Need help using basic unix commands on MAC. Here is what I need to do to the data.

Get the movies that were made after 1980 (that is, ’year’ column has a number greater than 1980). Hint: apply a pattern to see if number is ”198[…]” or a larger number.  

The file is located at https://github.com/hashTagKehl/imdb/blob/master/clean-imdb.csv.

Maybe this help - https://unix.stackexchange.com/questions/399710/how-to-filter-range-of-date-from-a-particular-column-of-a-csv-file 

PS: I am a windows user, but can do this in PHP.

Hi @hashtagkehl,

This post was moved to a different board that fits your topic of discussion a bit better. This means you’ll get better engagement on your post, and it keeps our community organized so users can more easily find information.

As you’ll notice, your topic is now here in the Project Development Help and Advice board. No action is needed on your part; you can continue the conversation as normal here.

Cheers!

thanks, the instructions don’t want us to use awk, just cut and sed

I used this for removing the second column, seems to work

cut -f1,3- -d’,’ clean-imdb.csv >newClean-imdb.csv