the cloud Dependency Minimum Version Notes fsspec 0.7.4 Handling files aside from simple local and HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.12.0 Google Big Query access s3fs 0.4.0 Amazon tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/master/pandas/tests/io/data/csv/tips.csv" ...: ) ...: In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/master/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

the cloud Dependency Minimum Version Notes fsspec 0.7.4 Handling files aside from simple local and HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.12.0 Google Big Query access s3fs 0.4.0 Amazon tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" (continues on next page) 74 Chapter 1. Getting started pandas: powerful In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/master/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

the cloud Dependency Minimum Version Notes fsspec 0.7.4 Handling files aside from simple local and HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.12.0 Google Big Query access s3fs 0.4.0 Amazon tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/master/pandas/tests/io/data/csv/tips.csv" ...: ) ...: In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/master/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

the cloud Dependency Minimum Version Notes fsspec 0.7.4 Handling files aside from simple local and HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.14.0 Google Big Query access s3fs 0.4.0 Amazon tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" (continues on next page) 74 Chapter 1. Getting started pandas: powerful In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/main/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

the cloud Dependency Minimum Version Notes fsspec 0.7.4 Handling files aside from simple local and HTTP gcsfs 0.6.0 Google Cloud Storage access pandas-gbq 0.14.0 Google Big Query access s3fs 0.4.0 Amazon tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" (continues on next page) 74 Chapter 1. Getting started pandas: powerful In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/main/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

cloud Dependency Minimum Version Notes fsspec 2021.5.0 Handling files aside from simple local and HTTP gcsfs 2021.5.0 Google Cloud Storage access pandas-gbq 0.15.0 Google Big Query access s3fs 2021 tips and assume we have a database table of the same name and structure. In [3]: url = ( ...: "https://raw.github.com/pandas-dev" (continues on next page) 1.4. Tutorials 75 pandas: powerful Python In pandas, you pass the URL or local path of the CSV file to read_csv(): In [5]: url = ( ...: "https://raw.github.com/pandas-dev" ...: "/pandas/main/pandas/tests/io/data/csv/tips.csv" ...: ) ...:

called tips and assume we have a database table of the same name and structure. In [3]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [4]: tips replace; getnames=yes; run; The pandas method is read_csv(), which works similarly. In [5]: url = ('https://raw.github.com/pandas-dev/' ...: 'pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips with other tools 197 pandas: powerful Python data analysis toolkit, Release 0.25.1 In [5]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips

called tips and assume we have a database table of the same name and structure. In [3]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [4]: tips replace; getnames=yes; run; The pandas method is read_csv(), which works similarly. In [5]: url = ('https://raw.github.com/pandas-dev/' ...: 'pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips with other tools 197 pandas: powerful Python data analysis toolkit, Release 0.25.0 In [5]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips

called tips and assume we have a database table of the same name and structure. In [3]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [4]: tips toolkit, Release 0.24.0 The pandas method is read_csv(), which works similarly. In [5]: url = ('https://raw.github.com/pandas-dev/' ...: 'pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips Additionally, it will automatically download the data set if presented with a url. In [5]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips

called tips and assume we have a database table of the same name and structure. In [3]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [4]: tips replace; getnames=yes; run; The pandas method is read_csv(), which works similarly. In [5]: url = ('https://raw.github.com/pandas-dev/' ...: 'pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips Additionally, it will automatically download the data set if presented with a url. In [5]: url = ('https://raw.github.com/pandas-dev' ...: '/pandas/master/pandas/tests/data/tips.csv') ...: In [6]: tips