Akhri CSV iyada oo loo marayo proxy iyadoo la isticmaalayo pandas iyo Requests

Soo qaado CSV iyadoo la isticmaalayo Requests transport la habeeyay, hubi natiijada HTTP, oo sii pandas buffer byte ah si loo falanqeeyo.

Marka jidka HTTP uu u baahan yahay maamul proxy oo cad, marka hore soo qaado CSV-ga oo u dhaaf pandas inuu maareeyo bytes-ka soo baxa:

from io import BytesIO
import pandas as pd
import requests

route = {
    'http': 'http://proxy.example:8080',
    'https': 'http://proxy.example:8080',
}
with requests.get(
    'https://data.example/report.csv',
    proxies=route,
    timeout=(5, 30),
) as response:
    response.raise_for_status()
    frame = pd.read_csv(BytesIO(response.content), encoding='utf-8')

Proxy ayaa maamusha gaadiidka; liiska proxy HTTP ayaa bixiya musharrixiinta barta ugu dambeysa ee jid HTTP dadweyne. pandas wuxuu helaa shay u eg fayl oo codsada doorashadiisa caadiga ah ee kala-soocidda, tiirarka, encoding-ka iyo noocyada xogta.

Hubinta natiijada HTTP ka hor falanqaynta waxay ka hortagtaa in jirka khalad HTTP oo cad loo tixgeliyo shax ahaan. Sidoo kale baar waxyaabaha aan la filaynin: bogga gelitaanka ama siyaasadda ayaa laga yaabaa inuu soo celiyo 200 oo weli HTML noqdo halkii CSV la codsaday.

URL-yada HTTP, storage_options-ka read_csv waxaa loo gudbiyaa sida madaxyada codsiga. Interface-kaas maaha khariidad proxies qaab Requests.

Buffer ma laha magac fayl kayd ah oo hagaya qiyaasta isku-buurninta. Caddayso compression marka xogta la soo qaaday ay u baahan tahay. Isla habka marka-hore-soo-qaado wuxuu la shaqeeyaa read_excel iyo buffer byte, iyadoo la isticmaalayo matoorka spreadsheet-ka ku habboon qaabkaas.

Tusaalahan wuxuu jawaabta oo dhan ku hayaa xusuusta. Dhoofin weyn, ku qulquli fayl maxalli ah oo la maamulo oo falanqee faylkaas, iyadoo loo qaybinayo qaybo halka socodka xogta uu taageero.

Maqaallo la xiriira