Bash read csv file using awk and save output in array

Question

I have an excel file and column 10 has multiple values like below,

Designation Header
-----------------
Student
Teacher
Teacher
Organization Director
Organization Director
Organization Head
Student
Organization Head
Organization Director
Teacher

I am trying to get the unique values from this column and the number of rows corresponding to each unique value in an associative array.

Here is the command I am using to get the unique value and number of rows,

awk -F',' 'NR>1{print $10}' Sorted_File.csv | sort | uniq -c

This gives me output as below,

 2 Student
 3 Teacher
 3 Organization Director
 2 Organization Head

How do I save this output in an associative array i.e key-value pair?

Well, sh doesn't have associate arrays.... are you targeting bash or zsh? — Shawn
– Shawn, Commented Jul 26, 2021 at 2:35

tshiono · Accepted Answer · 2021-07-26 03:00:26Z

1

Another bash version without awk:

declare -A counts
while IFS=, read -r -a ary; do
    (( counts[${ary[9]}]++ ))
done < <(tail -n +3 Sorted_File.csv)

declare -p counts

answered Jul 26, 2021 at 3:00

tshiono

22.3k2 gold badges18 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shawn · Accepted Answer · 2021-07-26 02:49:46Z

0

In bash, it'd be something like:

#!/usr/bin/env bash

declare -A counts
while read -r cnt what; do
    counts[$what]=$cnt
done < <(awk -F',' 'NR>1{print $10}' Sorted_File.csv | sort | uniq -c)

declare -p counts

Basically, read the output of your original pipeline in a loop, adding each pair of values to the associate array.

answered Jul 26, 2021 at 2:49

Shawn

53.9k3 gold badges29 silver badges74 bronze badges

Collectives™ on Stack Overflow

Bash read csv file using awk and save output in array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related