SASDigitalHumanitiesTraining / Visualisation

Data visualisation for Ancient and Modern History, Languages and Literature
1 stars 0 forks source link

Group B: Roman Amphitheaters using RawGraphs.io #10

Closed Ellis307 closed 3 years ago

Ellis307 commented 4 years ago

Hello! Could I have some advice?

I'm in the group looking at Roman Amphitheaters in RawGraphs.io, but haven't been able to get the website to do anything when I copy and paste the dataset into it. I thought I might have done something wrong and so I pasted the early women graduates dataset into rawgraphs and it 'successfully parsed'. I'm hoping the point is that 'it is difficult to know where you've gone wrong'?

jonathanblaney commented 4 years ago

@Ellis307

It can be difficult if the site doesn't give you any feedback, like a parsing error and a line number.

In these cases I start by seeing what I can get to parse. You've already done that with the grads data so I would try cutting down the Amphitheaters data into a couple of lines and see if you can get that to parse.

gabrielbodard commented 4 years ago

Just for the record, I'm replicating this problem, and the Amphitheatres data doesn't seem to parse, but with such an absence of error message that at first I thought I just hadn't found the "submit" button or something. I followed Jonathan's advice and just pasted in a few lines, but it doesn't seem to parse even just the first line.

(╯°□°)╯︵ ┻━┻

I would suggest playing with a different dataset (e.g. the Mithraea) in the meantime, just to get some experience with Rawgraphs.

jonathanblaney commented 4 years ago

I manage to get this to parse but in a slightly cumbersome way:

  1. Pasted the data into a text editor, eg Atom or Notepad, and saved it as amph.csv
  2. Opened that file in Excel and saved it again as amph.xslx
  3. Upload the Excel-format file to RawGraphs.

I'm guessing that RawGraphs is having a problem with a delimiter - telling the difference between a comma separating actual values and one used within values. Excel seems to enforce a choice in these cases, which at least makes the file parse. But I'm not sure that's the explanation.

gabrielbodard commented 4 years ago

Interesting. I got that to work just by opening the downloaded csv directly in Excel (not sure why you needed the cut and paste step first?). (I was also able to paste the content directly from Excel.) I wonder what the text file is b0rking? (I don't see any commas in the XSLX, but that may be because it's fixed them, as Jonathan suggests…)

jonathanblaney commented 4 years ago

Great, that method is more streamlined (I was using Edge on my work laptop and it's not obvious how you can download a page; I really need to change my default browser).

Ellis307 commented 4 years ago

It is working now, thank you very much!

gabrielbodard commented 4 years ago

A question for the Amphitheatres groups (in case you have time to look at this again before the session, or want to answer later): could you use a visualisation to test the hypothesis that there is a correlation between theatre capacity and altitude?

Ellis307 commented 4 years ago

There does seem to be quite a strong correlation between theatre capacity and altitude. Altitude has little to no effect for theatres under 20,000 capacity, but there is a clear drop off beyond this figure. (The X axis is capacity, and Y axis elevation) Filename

Ellis307 commented 4 years ago

Beeswarm - capacity on X Axis, second century as colour Filename (1)

Contour Map with labels (X axis – longitude, Y axis – latitude)

Contour with labels

Contour Map without labels (X axis – longitude, Y axis – latitude)

Contour without labels

Jmuccigr commented 4 years ago

There does seem to be quite a strong correlation between theatre capacity and altitude. Altitude has little to no effect for theatres under 20,000 capacity, but there is a clear drop off beyond this figure. (The X axis is capacity, and Y axis elevation) Filename

Well, I’d agree there’s no correlation for 20k and below capacity. Then there are no 20k+ amphitheaters much above sea level.

Anybody got urban population v altitude?