How to read a csv from a URL in Python?
Published on Aug. 22, 2023, 12:19 p.m.
To read a CSV file from a URL in Python, you can use the pandas
library. Here’s an example:
import pandas as pd
url = 'https://www.example.com/data.csv'
df = pd.read_csv(url)
In this example, we start by importing pandas
using the import
statement.
We then set the url
variable to the URL of the CSV file that we want to read.
Next, we use the pd.read_csv()
function to read the CSV file from the specified URL and load it into a DataFrame
called df
.
That’s all there is to it! Now you can use the df
variable to work with the CSV data as needed.
Note that you will need to have the pandas
library installed in order to use this functionality. You can install it using pip
:
pip install pandas
Also, ensure you replace the example URL with an appropriate URL for your CSV data.