Menu
Article Case Studies

python requests module csv

Narkw Brahma

Narkw Brahma

• 2 min read

Python Requests Module CSV

The Python Requests module is a powerful tool for making HTTP requests. It can easily handle various HTTP methods such as GET, POST, PUT, DELETE, etc. The CSV (Comma Separated Values) format is a popular way to store data in a tabular format. In this blog post, we will explore how to use the Python Requests module to work with CSV files.

Installing Requests Module

To use the Python Requests module, you need to first install it. You can install it using the pip package manager as follows:


    pip install requests

Reading CSV Files

The Python Requests module can be used to read a CSV file from a URL or from a local file system. To read a CSV file from a URL, you can use the get() method of the requests module. Here is an example:


    import requests
    import csv
    
    url = 'https://example.com/data.csv'
    response = requests.get(url)
    
    content = response.content.decode('utf-8')
    reader = csv.reader(content.splitlines(), delimiter=',')
    
    data = list(reader)
    print(data)

In this example, we first import the requests and csv modules. We then define the URL of the CSV file that we want to read. We use the get() method of the requests module to fetch the contents of the URL. We then decode the content using UTF-8 encoding and create a CSV reader object using the csv.reader() function. Finally, we convert the CSV reader object to a list and print it.

If you want to read a CSV file from a local file system, you can use the open() function to open the file and pass the file handle to the csv.reader() function. Here is an example:


    import csv
    
    with open('data.csv', 'r') as f:
        reader = csv.reader(f)
        data = list(reader)
        print(data)

In this example, we use the open() function to open the data.csv file in read mode. We then create a CSV reader object using the csv.reader() function and pass the file handle to it. Finally, we convert the CSV reader object to a list and print it.

Writing CSV Files

The Python Requests module can also be used to write data in CSV format. To write data to a CSV file, you can use the csv.writer() function. Here is an example:


    import requests
    import csv
    
    url = 'https://example.com/write-data.php'
    data = [
        ['John', 'Doe', '[email protected]'],
        ['Jane', 'Doe', '[email protected]']
    ]
    
    response = requests.post(url, data={'csv_data': data})
    print(response.text)

In this example, we define the URL of the script that will receive the CSV data. We then define a list of lists containing the data that we want to write to the CSV file. We use the post() method of the requests module to send the data as a POST request. We pass the data as a dictionary with the key 'csv_data'. Finally, we print the response from the server.

Conclusion

The Python Requests module is a powerful tool for working with various HTTP requests. It can be easily used to read and write CSV files. In this blog post, we discussed how to use the Requests module to work with CSV files. We covered reading CSV files from a URL and a local file system, and writing data to a CSV file.

Share