![]() We saw in Notepad++ that the file encoding is UTF-8. For doing so, we'll first launch SPSS and navigate to csv file that we'll open in SPSS can be downloaded from browsers.csv. This enables us to compare our manually edited file with the original file as GA generated it. After doing so, we'll save it with a different file name. It basically tells how characters are mapped onto the bits (ones and zeroes) that the file really consists of. Last but not least, note “UTF-8” in the status bar. Lines 319 and below contain summary statistics which are not part of the data we want. ![]() ![]() If we quickly scroll down the file (tip: use the pgdn key on your keyboard), we see that line 318 is the last line containing raw data values. These quotes indicate that commas between them are not meant as delimiters. If a value contains a comma, there's double quotes around it. Note how data values are separated by commas (hence “comma separated values” or. The actual data start on line 8, which will be the second line of data after removing the first 6 lines. Note that most of them are not suitable for SPSS because they contain spaces or start with a percent sign. We'll remove them after inspecting the rest of the data. Note that the first 6 lines of the file are a basic description of the data. ![]() The screenshot below shows what the data look like in Notepad++. As we'll see in a minute, this allows us to gather some essential pieces of information on the file contents. However, a better idea is to inspect the file with notepad++ or a similar text editor. csv files are typically associated with spreadsheet editors such as MS Excel or OpenOffice Calc. We'll take our time to explain and resolve these issues. We chose it because opening it in SPSS causes some complications that you'll typically encounter with real life data. The original data file -as generated by GA- can be downloaded here. Since many readers may be unfamiliar with GA, the screenshot below gives a basic idea of what the data look like before we export them as a. csv file as obtained from Google Analytics (GA). This tutorial walks you through opening a. SPSS – Open CSV Data File By Ruben Geert van den Berg under SPSS Blog Summary
1 Comment
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |