How Do You Read CSV Files From URLs Using Pandas?

Reading CSV Files from URLs Using Pandas

When attempting to read a CSV file from a URL using Python 3.x, users may encounter the error: "Expected file path name or file-like object, got type."

This occurs because Pandas expects a file path or an open file object, while the code provides a byte-string s obtained from the URL. To resolve this issue, follow the updated Pandas implementation:

In Pandas versions later than 0.19.2, you can directly pass the URL to the read_csv() function:

<code class="python">import pandas as pd

# Replace the s variable with the direct URL
url = "https://raw.githubusercontent.com/cs109/2014_data/master/countries.csv"
c = pd.read_csv(url)</code>

This updated code directly reads the CSV data from the specified URL without the need for intermediate steps involving requests.get().content.

The above is the detailed content of How Do You Read CSV Files From URLs Using Pandas?. For more information, please follow other related articles on the PHP Chinese website!