It's UWAweek 26 (mid-year break)

helpOSTS

This forum is provided to promote discussion amongst students enrolled in Open Source Tools and Scripting.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying the 5 articles in this topic
Showing 5 of 439 articles.
Currently 9 other people reading this forum.


 UWA week 18 (1st semester, week 9) ↓
SVG not supported

Login to reply

👍?
helpful
12:51pm Sun 5th May, ANONYMOUS

Hi professor,

which will use Bash plus Shell tools, to clean the data. cantril_data_cleaning expects three .tsv file ----------but the data given one of the file is .csv.

are we supposed to convert it?


 UWA week 19 (1st semester, week 10) ↓
SVG not supported

Login to reply

👍?
helpful
10:44am Mon 6th May, Michael W.

ANONYMOUS wrote:

Hi professor,

which will use Bash plus Shell tools, to clean the data. cantril_data_cleaning expects three .tsv file ----------but the data given one of the file is .csv.

are we supposed to convert it?

Hi, That was a mistake on my part. Now fixed. Long story short, a csv file would be an error as it cannot be interpreted as a .tsv file.

Cheers MichaelW


SVG not supported

Login to reply

👍?
helpful
11:39am Mon 6th May, Zexu D.

Ops, that's sad coz I just accomplished the file format conversion in my script last night.🥲


SVG not supported

Login to reply

👍?
helpful
9:00pm Mon 6th May, Michael W.

"Zexu Ding" [email protected] wrote:

Ops, that's sad coz I just accomplished the file format conversion in my script last night.🥲

Hi Zexu, I am impressed. It's actually not trivial as .csv data can have commas in the strings, and also hidden . Was your solution able to cope with these?

Cheers MichaelW 👨‍🎨


SVG not supported

Login to reply

👍?
helpful
12:29pm Tue 7th May, Zexu D.

Yes, I've seen that point. I took a lot of effort to craft a regex to ignore the comma within the quoted fields.

And I'm surprised how challenging it could be, for those CS beginners, but also interesting.

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  5:07AM Sep 06 2023
Privacy policy