I am trying to read a excel file.
import requests
url = '
r = requests.get(url, allow_redirects=True)
open('todayprice.xls', 'wb').write(r.content)
import pandas as pd
pd.set_option("xls", "openpyxl")
fileurl='todayprice.xls'
df=pd.read_excel(fileurl)
print(df)
I get an error saying:
raise OptionError("Pattern matched multiple keys")
pandas._config.config.OptionError: 'Pattern matched multiple keys'
6 Answers
This error often happens when people use older codes for pandas options, like precision. Starting in 1.4 some of these are replaced with longer forms, like display.precision.
Solution: visit list of options in pandas docs and find the updated name for your option.
I'd like to add that the error message Pattern matched multiple keys is quite confusing. Pandas team may want to change it.
In the new Pandas version, you need to use the code below to get the desired output.
pd.options.display.max_rows = 5
You can try with the option io.excel.xls.reader instead of just xls.
From the doc:
Regexp which should match a single option. Note: partial matches are supported for convenience, but unless you use the full option name (e.g. x.y.z.option_name), your code may break in future versions if new options with similar names are introduced.
Both Pd.set_option("display.max_columns",100) And Pd.options.display.max_columns=100
Perform the same role
pd.set_option("display.max_columns", 100) solved my problem.
Tried various methods like: pd.set_option('max_columns', 35)
but the below format will surely help:
pd.set_option("display.max_columns", 100)
