Desafio 01

library(reticulate) #abrindo o pacote reticulate

virtualenv_create("env_me315", python = "C:/Program Files/Python312/python.exe") #criando um ambiente virtual pra usar python

virtualenv: env_me315

use_virtualenv("env_me315", required = TRUE) #manda usar o ambiente virtual criado
py_config() # mostra as informações de configuração do Python que o reticulate está usando 

python:         \\smb/ra237599/Documentos/.virtualenvs/env_me315/Scripts/python.exe
libpython:      C:/Program Files/Python312/python312.dll
pythonhome:     \\smb/ra237599/Documentos/.virtualenvs/env_me315
version:        3.12.0 (tags/v3.12.0:0fb18b0, Oct  2 2023, 13:03:39) [MSC v.1935 64 bit (AMD64)]
Architecture:   64bit
numpy:          \\smb/ra237599/Documentos/.virtualenvs/env_me315/Lib/site-packages/numpy
numpy_version:  2.3.3

NOTE: Python version was forced by use_python() function

py_install("pandas", envname = "env_me315") #instalando o pandas

Using virtual environment "env_me315" ...

+ //smb/ra237599/Documentos/.virtualenvs/env_me315/Scripts/python.exe -m pip install --upgrade --no-user pandas

ini <- Sys.time()
dados <- read.csv(unz("flights.csv.zip", "flights.csv"))
fim <- Sys.time()
fim - ini

Time difference of 1.170643 mins

library(readr)

Warning: package 'readr' was built under R version 4.3.3

ini <- Sys.time()
dados <- read_csv('flights.csv.zip')

Rows: 5819079 Columns: 31
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (11): AIRLINE, TAIL_NUMBER, ORIGIN_AIRPORT, DESTINATION_AIRPORT, SCHEDUL...
dbl (20): YEAR, MONTH, DAY, DAY_OF_WEEK, FLIGHT_NUMBER, DEPARTURE_DELAY, TAX...

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

fim <- Sys.time()
fim - ini

Time difference of 25.95921 secs

import time
import pandas as pd
ini = time.time()
dados = pd.read_csv("flights.csv.zip", compression="zip", header=0, sep=",", low_memory=False)
fim = time.time()
fim - ini

28.499469995498657