Closed hungrymonkey closed 5 years ago
The destionations tend to be the general location The departures display the cities
The files are formatted as name_of_location,frequency
The files are generated by these two commands
awk -F " , " '{print $5}' northamericacruisedetaildata.csv | sed -e 's/^[ \t]//' | sort | awk '{ a[$1]++ } END { for (n in a) print n","a[n] } ' | sort > destinations.csv awk -F " , " '{print $4}' northamericacruisedetaildata.csv | sed -e 's/^[ \t]//' | sort | awk '{ a[$1]++ } END { for (n in a) print n","a[n] } ' | sort > departures.csv
The destionations tend to be the general location The departures display the cities
The files are formatted as name_of_location,frequency
The files are generated by these two commands
awk -F " , " '{print $5}' northamericacruisedetaildata.csv | sed -e 's/^[ \t]//' | sort | awk '{ a[$1]++ } END { for (n in a) print n","a[n] } ' | sort > destinations.csv awk -F " , " '{print $4}' northamericacruisedetaildata.csv | sed -e 's/^[ \t]//' | sort | awk '{ a[$1]++ } END { for (n in a) print n","a[n] } ' | sort > departures.csv