Character encoding 1. Character encoding 1a) Character encodingComputers deal with everything in zeros and ones, including letters.Characters are one byte: a series of eight zeros and ones.Each character had a value that could go from one to 255:(binary) 00000001 = (decimal) 1 /(binary) 11111111 = (decimal) 255 /Each letter of the alphabet and other symbols fall on this range:Letter ‘a’ is 97 on this range, ‘b’ is.. 더보기 OpenRefine 1) Why OpenRefine It’s free of charge.It’s open source, allowing for improvements by its users.It’s more powerful and easier to use than Microsoft Excel.It’s not localised, so the functions are always in English. This makes work easier to share.1a) Installing OpenRefine OpenRefine:Download and install the version fitting to your computer.No admin privileges are needed to run OpenRefine.For issue.. 더보기 Making-new-variables-with-functions Add columns and rows of numbersCalculate ratesDo date arithmeticCalculate averages and medians using spreadsheet functionsDatamania (1:00)1) Creating a new variable: in a new column add a variable name and in the row below add the formula for the new variableAlways sort the new variable after creation to see if there is anything interesting.1a) Adding two variables:Every Excel formula starts wit.. 더보기 이전 1 ··· 38 39 40 41 42 43 44 ··· 57 다음