sc-wrangle repo says about data wrangling commands. By these commands, I wrangled the data of shakeshpeare under tragedy. The play name is "THE LIFE AND DEATH OF JULIUS CAESAR"

Note: I used the speakers of Antony and Octavius to count how many times they spoke.

• entireplay.txt - Input file Copied and pasted entire text in this file.
• nopunct.txt - entireplay file without punctuation

tr -d [:punct:] <entireplay.txt> nopunct.txt

Note: I have used this command to take speakers names without puctuation marks.

• antony.txt - File with count of how many times antony speaks

grep -i 'ANTONY' nopunct.txt -c > antony.txt

Note: i is the case sensitive. So it takes only capital letters.

• octavius.txt - File with count of how many times octavius speaks

grep -i 'OCTAVIUS' nopunct.txt -c > octavius.txt

• ao.txt - Both antony and octavius count in file

$ paste antony.txt octavius.txt >ao.txt

Note: This command directly be used as below command,but if you want to look how they paste in a file,then use it as. sample.

• output.txt - summation of antony and octavius count

$ paste antony.txt octavius.txt | awk '{print $1+$2;}' >output.txt

Tragedy, 4, The Life and Death of Julius Caesar

• Antony

• OCTAVIUS

I asked count of speakers and sum of them

• Antony - 125
• OCTAVIUS - 43
• SUM - 168

Tell us the answer. my last command

$ paste antony.txt octavius.txt | awk '{print $1+$2;}' >output.txt