Exercise Processing Csv Files Using A Dictionary Of Lists - Notebook by Miguel Díaz Campos (diazca-miguel91)

Learn practical skills, build real-world projects, and advance your career

Updated 3 years ago

Run on Colab

Run on Kaggle

Run on Binder

Duplicate

import os
import numpy as np
import urllib.request
import math

os.makedirs('./data2', exist_ok=True)

url1 = 'https://gist.githubusercontent.com/aakashns/257f6e6c8719c17d0e498ea287d1a386/raw/7def9ef4234ddf0bc82f855ad67dac8b971852ef/loans1.txt'
url2 = 'https://gist.githubusercontent.com/aakashns/257f6e6c8719c17d0e498ea287d1a386/raw/7def9ef4234ddf0bc82f855ad67dac8b971852ef/loans2.txt'
url3 = 'https://gist.githubusercontent.com/aakashns/257f6e6c8719c17d0e498ea287d1a386/raw/7def9ef4234ddf0bc82f855ad67dac8b971852ef/loans3.txt'

urllib.request.urlretrieve(url1, './data2/loans1.txt')
urllib.request.urlretrieve(url2, './data2/loans2.txt')
urllib.request.urlretrieve(url2, './data2/loans3.txt')

('./data2/loans3.txt', <http.client.HTTPMessage at 0x7f85280f9130>)

def open_data(path):
    with open(path) as file:
        data = file.readlines()
    return data
data = open_data('./data2/loans2.txt')
data

['amount,duration,rate,down_payment\n',
 '828400,120,0.11,100000\n',
 '4633400,240,0.06,\n',
 '42900,90,0.08,8900\n',
 '983000,16,0.14,\n',
 '15230,48,0.07,4300']