HW 3, CS 625, Fall 2022

Gabriela Gamez Sept 28, 2022

Git, GitHub

  1. What is your GitHub username?

csggame001

Part 1 - Choose Line chart #1, use R to re-created

For each part, your report must include the following items:

Original_Line_chart_#1

re-created _Line_chart

Description of how created the chart in the tool of choice

One of the first steps for recreating Line chart #1 was downloading PolicyViz_WSJ_Remake.xlsx from the link provided within “Homework 3: Re-create Charts”. After downloading, open the PolicyViz_WSJ_Remake.xlsx using Excel to access the information in the file: the file includes the bar chart image, a link, and data use, as seen in Figure 1.

Figure 1

To recreate the chart, we only need the data, so remove the bar chart image and the link and save it as PolicyViz_WSJ_Remake_remove_graph.xlsx , as seen in Figure 1.1

Figure 1.1

The following step after having this new file is to convert the PolicyViz_WSJ_Remake_remove_graph.xlsx to a CSV file and JSON file. We will be using openrefine-3.5.2 to convert to CSV. Open openrefine.exe by double clicking on the executable this with running a small server on the computer and opening a web browser to allow us to interact with it. The open web browser indicated the location to where the PolicyViz_WSJ_Remake_remove_graph.xlsx is saved.

Click on Chosen Files -> select the file location-> click Next>>, as seen in the image below.

Unselect the PolicyViz_WSJ_Remake_remove_graph.xlsx#Notes, rename the Project name to “PolicyViz WSJ Remake” and click Create Project, as seen in the image below.

Export file as Comma-separated value to export as CSV. The file should appear as PolicyViz-WSJ-Remake.csv

After converting the CSV file, the next step is to transform it into a JSON file by using the Convert CSV to JSON. On the section that said “Step 1: Select your input,” click Choose File within this section indicated the location of where PolicyViz-WSJ-Remake.csv is saved.

After indicating the file location, scroll down to the section that says “Step 5: Generate output” and click on Download Result; this will download a file name “PolicyViz-WSJ-Remake.json”

Now the we have the data convert to XLS, CSV and JSON allow gives us more freedom into selecting the the tool for recreating the graph.

For the recreating, we will be using the language R. Exel would have been ideal, but it is an application that is easy to use, and R is a language that we are learning this semester. We use professor notes plus other resources.

Open 625-F21-Marks-Channels-R.ipynb and scroll down to Charts from Vega-Lite Examples; this section shows how to load the data to google colab. The list for loading the data are library(jsonlite) and the public repository containing the JSON file.

Start by openning GitHub and create a public repository with GitHub containing the files created. Navigate the upper left column and click on the down arrow from the plus symbol ->select New repository .

Enter the “cs_625_data” for Repository name, select the Public option and Add a README file and click create repository.

In the README file enter a description for the repository ” this contains the provide xls files save as json file and CSV for Homework 3: Re-create Charts”. Finally add the files to the repository by click Add file this will open a drop-down menu selected Upload files.

Drag and drop all the files into this repository, as seen in the image below, enter a description of the files and commit changes.

Now that our data is within a public repository, we can finally start the actual recreation process. Let’s begin the original analysis image of line chart #1 and list everything noticeable on the graph. This will help us with recreation by spotting all the details we need to include.

assessment of how close you were able to re-create each chart (what things were you not able to re-create?)

assessment of the tool you used and how flexible it was in terms of being able to re-create the chart

explain how the idiom choice is appropriate for the data and the task

Part 2 - Choose Small Multiples Bar chart, use Tableau to re-created

For each part, your report must include the following items:

Original Small Multiples Bar chart

Re-created chart image

Re-create Small Multiples Bar chart

References

Every report must list the references that you consulted while completing the assignment. If you consulted a webpage, you must include the URL.

Need this references are from HW2 need to add HW 3