Linux bash question, need help with b) and c), use sed to manipulate the csv fil

Question

Linux bash question, need help with b) and c), use sed to manipulate the csv file

inteff.csv LibreOffice Calc File Edit View nsert Format Sheet Data Tools Window Help Liberation Sans 10 A1 experiment sel Compl Net ol signif experiment mixture int 2 GEM plpru 5.74 0.35 87 1.22 1.05 1 plach 3.5 0.29 0.49 0.78 0.99 1 3 GE1 plagr 4.01. 0.16 1.02 1.19 1.04 1 4 GE1 5 GE1 pruach 1.7 0.49 1.11 0.59 0.9 3.53 0.28 0.7 0.99 0.96 1 6 GE1 pruagr 7 GE ach agr 0.91 0.17 o.34 0.51 0.93 o 8 SE ssws 1534.1 3005.86 1328.04 4333.88 -0.302 o 9 SE sssb 23375.7 3869.44 2510.24 6379.69 -0.303 1 10 SE sswb 270.6 1341.25 1807.93 3149.18 -0.323 o 11 SE wssb 45576 6630.44 2313.1 8943.54. -0.268 1 12 SE wswb 16267.2 3346.4 1911.01 5257.42 -0.295 1 13 SE sbwb 13380.7 4008.27 1829.7 5838 -0.223 1 14 GE2 holfes 3.448 0.9438944 0.3293109 1.273205 -0.04908214 1 15 GE2 holbri 3.58 1.0694224 0.2090239 1.278446 -0.06127105 1 16 GE2 holpru 3.969 1.0414018 0.2403681 1.28177 -0.05896012 1 GE2 hollys 6.771 1.29716 0.2498069 1.546967 -0.04933826 1 17 GE2 fesbri 4.184 0.8729319 0.3214404 1.194372 -0.02448218 1 18 19 GE2 feslych 4.054 0.7523545 0.5080307 1.260385 -0.00280154 1 GE2 feslys 6.471 1.0964593 0.364369 1.460828 -0.00995637 1 20 GE2 lychpru 3.298 0.799972 0.3770637 1.177036 -0.02814007 1 21 GE2 lychlys 4.637 1.0729912 0.3721899 1.445181 -0.01427926 1 22 23 GE2 prulys 4.724 1.0823695 0.3028857 1.385255 -0.0217101 1 24 GE2 hollych 1.898 0.8781065 0.3789874 1.257094 -0.05125533 0 25 GE2 fespru 1.656 0.8337331 0.3235583 1.157291 -0.03105034 0 GE2 bilych 2.255 0.8517545 0.3187053 1.17046 -0.03255674 o 26 inteff Sheet 1 of 1 Default Sum 0 110%

Explanation / Answer

1)))))) firstly visit the home tab and then go the dialog box launcher which will be adjacent to the number

visit the catagory box

visit the numbers

in the negative number box cick the format.

2))))))

use the filter command such that text length is 4

3))))))))

select the column that you want to change from upper case to lower case and then use the function lower to convert upper case to lower case.

and then save it as a new file with the name inteff2.csv

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.