Use the encoding keyword with the appropriate parameter:

df = pd.read_csv('1459966468_324.csv', encoding='utf8')

This works in Mac as well you can use

df= pd.read_csv('Region_count.csv', encoding ='latin1')

Simplest of all Solutions:

import pandas as pd
df = pd.read_csv('file_name.csv', engine='python')

Alternate Solution:

Sublime Text:

• Open the csv file in Sublime text editor or VS Code.
• Save the file in utf-8 format.
• In sublime, Click File -> Save with encoding -> UTF-8

VS Code:

In the bottom bar of VSCode, you'll see the label UTF-8. Click it. A popup opens. Click Save with encoding. You can now pick a new encoding for that file.

Then, you could read your file as usual:

import pandas as pd
data = pd.read_csv('file_name.csv', encoding='utf-8')

and the other different encoding types are:

encoding = "cp1252"
encoding = "ISO-8859-1"

tl;dr

For your situation, you probably need one of these:

pd.read_csv(file, encoding='utf-8', encoding_errors='replace')
# or
pd.read_csv(file, encoding='utf-8', encoding_errors='ignore')

Longer answer

As of version 1.3+ of pandas.read_csv() you can pass argument encoding_errors.

Possible values:

• strict: Raise UnicodeError (or a subclass); this is the default.
• ignore: Ignore the malformed data and continue without further notice.
• replace: Replace with a suitable replacement marker; Python will use the official U+FFFD REPLACEMENT CHARACTER for the built-in codecs on decoding, and ‘?’ on encoding.
• xmlcharrefreplace: Replace with the appropriate XML character reference (only for encoding).
• backslashreplace: Replace with backslashed escape sequences.
• namereplace: Replace with \N{...} escape sequences (only for encoding).
• surrogateescape: On decoding, replace byte with individual surrogate code ranging from U+DC80 to U+DCFF. This code will then be turned back into the same byte when the 'surrogateescape' error handler is used when encoding the data.
• surrogatepass: Allow encoding and decoding of surrogate codes. These codecs normally treat the presence of surrogates as an error.