O'Reilly logo

Practical Business Intelligence by Ahmed Sherif

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fusing D3 and CSV

Now that we have some background on how to create components with D3 using hardcoded data in variables, we can continue the process by developing D3 components against data in a CSV file. In order to do so, there are two architectural matters that will need to be addressed before any type of development begins:

  • Creating and exporting a CSV file to a desired location
  • Establishing a server to connect the CSV file to an HTML file to be leveraged by D3

Preparing the CSV file

In Chapter 2, Web Scraping, we scraped data from a GitHub website, which was extracted to a CSV file and then uploaded to MS SQL Server. The file was called DiscountCodebyWeek and contained the following three columns:

  • Index
  • WeekInYear
  • DiscountCode

When the data was ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required