GPU Database | TechPowerUp | Data Source from the Web (2024)

50

--

--

CSV JSON HTML Changes

import java.io.BufferedReader;import java.io.InputStreamReader;import java.net.URL;import java.net.URLConnection;import java.util.Arrays;public class HelloWorld { public static void main(String[] args) { try { URL urlCSV = new URL( "https://cache.getdata.io/n94681_dea832db567637536653b39ff0fa9e38eses/latest_all.csv" ); URLConnection urlConn = urlCSV.openConnection(); InputStreamReader inputCSV = new InputStreamReader( ((URLConnection) urlConn).getInputStream() ); BufferedReader br = new BufferedReader(inputCSV); String line; String[] fields; while ((line = br.readLine()) != null) { // Each row fields = line.split(","); System.out.println(Arrays.toString(fields)); } // clean up buffered reader br.close(); } catch (Exception e) { System.out.println(e.getMessage()); } } }

const csv = require('csv-parser');const https = require('https');const fs = require('fs');const file = fs.createWriteStream("temp_download.csv");const request = https.get( "https://cache.getdata.io/n94681_dea832db567637536653b39ff0fa9e38eses/latest_all.csv", function(response) { response.pipe(file); });file.on('finish', function() { file.close(); fs.createReadStream('temp_download.csv').pipe(csv()).on('data', (row) => { // Each row console.log(row); }).on('end', () => { console.log('CSV file successfully processed'); });});

$data = file_get_contents("https://cache.getdata.io/n94681_dea832db567637536653b39ff0fa9e38eses/latest_all.csv");$rows = explode("\n",$data);$s = array();foreach($rows as $row) { # Each row var_dump( $row); }

import csvimport urllib2url = 'https://cache.getdata.io/n94681_dea832db567637536653b39ff0fa9e38eses/latest_all.csv'response = urllib2.urlopen(url)cr = csv.reader(response)for row in cr: # Each row print row

require 'open-uri'require 'tempfile'require 'csv'temp_file = Tempfile.new( "getdata", :encoding => 'ascii-8bit')temp_file << open("https://cache.getdata.io/n94681_dea832db567637536653b39ff0fa9e38eses/latest_all.csv").readtemp_file.rewindCSV.foreach( open(uri), :headers => :first_row ).each do |row| # Each row puts rowend