search

leedrake5 / Russia-Ukraine

Equipment Loss Tracking
MIT License
617 stars 26 forks source link

column A variable definition in classes.csv #27

Open cpytaa opened 8 months ago

cpytaa commented 8 months ago

Hi! I just want to ask what is the meaning of the numbers in column A of classes.csv. Are those the same as sysID (system ID I presume?)

For example the 2023-11-13.csv of total by system, the row of cell D68, was "unknown towed artillery", and the value in cell H68 was 211 which I suppose was the system ID (sysID). When I go to the classes.csv, cell A605 which I thought is corresponding to the "unknown towed artillery" in towed artillery category, the number is "745".

I might be mixing up but I'd appreciate any guidance.

Thank you

leedrake5 commented 8 months ago

I don't think I understand - can you specify the folder path of the file and what the issue is? Note that classes was last updated in August. It takes a full day to deconflict that document with updates to scrub numbers from class names, so I aim to do it every 4 months.

cpytaa commented 8 months ago

class_daily Ah, sorry I forgot to specify the path. I was referring to this file: https://github.com/leedrake5/Russia-Ukraine/blob/main/data/bySystem/Raw/Daily/2023-11-13.csv The screenshot has the classes.csv on the left and the by system in the right. I was just wondering if the sysID is related to the numbers in the column A in any way.

I do see the challenges surrounding making the classes csv. A friend is interested in the weapons so I am trying to take a look at it too. If there is anything I can help with let me know.

leedrake5 commented 8 months ago

I think those are just row numbers automatically printed out by R during file export. I can probably write so,e code to automatically remove them.

cpytaa commented 8 months ago

Ah so those numbers have nothing to do with the sysID then. Got it. Thank you!