How do I import a dataset into jupyter notebook from a URL?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • feuerk
    New Member
    • Oct 2020
    • 3

    How do I import a dataset into jupyter notebook from a URL?

    I have tried these two codes and none of them seems to work. Can any of you help?

    Code:
    from numpy import loadtxt
    from urlib.request import urlopen
    
    url= 'https://think.cs.vt.edu/corgis/datasets/python/electricity/electricity.data'
    
    raw_data = urlopen(url)
    dataset = loadtxt(raw_data, dtype = 'str', delimiter = ",")
    
    print(dataset.shape)
    print()
    print(dataset[1:20])
    Code:
    import requests
    import pandas as pd
    URL ='https://think.cs.vt.edu/corgis/datasets/python/electricity/electricity.data'
    r = requests.get(URL)
    # a= eval(r.content) Never user eval for online texts
    df = pd.DataFrame(r.json())
Working...