Python 2.7: Handling UnicodeDecodeError when reading CSV files with special characters
I'm converting an old project and I'm experimenting with I'm working with a `UnicodeDecodeError` while trying to read a CSV file that contains special characters (like accented letters) using Python 2.7... Here's the code I've been using: ```python import csv with open('data.csv', 'r') as csvfile: reader = csv.reader(csvfile) for row in reader: print(row) ``` The `data.csv` file has entries like 'café', 'niño', and other similar characters. When I run the script, I get the following behavior: ``` UnicodeDecodeError: 'ascii' codec need to decode byte 0xc3 in position 0: ordinal not in range(128) ``` I've tried opening the file with the `encoding` parameter, but that doesn't seem to be available in Python 2.7's built-in `open`. I also attempted using the `codecs` module to open the CSV file: ```python import codecs with codecs.open('data.csv', 'r', encoding='utf-8') as csvfile: reader = csv.reader(csvfile) for row in reader: print(row) ``` However, this still results in the same `UnicodeDecodeError`. It looks like I might be missing something related to how the CSV data is being handled. Can anyone suggest a reliable way to read this CSV file correctly with special characters in Python 2.7? Any help would be greatly appreciated! For context: I'm using Python on Ubuntu. What am I doing wrong? I'm developing on Ubuntu 20.04 with Python. Could this be a known issue? This is for a application running on Linux. I appreciate any insights!