AWK is a powerful text-processing programming language. Given a multi-million lines of text file containing the following data – we want to know the frequencies the delegation at each integer interval e.g. 2, 3, 4:
First, we output the text file to console using cat then pipe it into grep to filter out non-data rows, and then we can execute the awk script.
cat steem3.txt | grep "delegates" | awk '$6 > 0 { data[int($6)]++ } END { for (sp in data) { print (sp, "=", data[sp]); } }'
It filters out the records that have zero values (undelegation records) – then we round the fraction numbers into integers and count them in a hash map.
Basically, we don’t have to declare the hash table prior to using it. And we can access it using the syntax map[key]. And at the END section, we can iterate the keys in the hash map in awk and print each value:
for (key in map) { print ("key is ", key, ", value is ", map[key]); }
–EOF (The Ultimate Computing & Technology Blog) —
loading...
Last Post: Using the Windows Hardware Tool to Error Checking and Optimize Your HardDrives
Next Post: Algorithms to Compute the Largest Time for Given Digits