tomatoiscoding · October 8, 2017 09:52
diff --git a/count b/count
 cut -d ',' -f1 FDADOS_CENSO2014.csv|tail-n +2|sort|uniq -c|sort -nr
diff --git a/count_null b/count_null
 # calculate the number of fields in a csv file
 head -n 1 FDADOS_CENSO2014.csv | awk -F ',' '{print NF}'
 # count null values using awk
 for j in {1..123}
 do
  awk -F, -v i=$j '$i==" "{N++} END{print N}' FDADOS_CENSO2014.csv >> empty
 done
diff --git a/dd b/dd
 awk -F, '$2!=" "' test1.txt > test2.txt
	# calculate the number of fields in a csv file
	head -n 1 FDADOS_CENSO2014.csv \| awk -F ',' '{print NF}'
	# count null values using awk
	for j in {1..123}
	do
	awk -F, -v i=$j '$i==" "{N++} END{print N}' FDADOS_CENSO2014.csv >> empty
	done
No results found