Type error using pandas

Guys, i tried to use two database, but when i use the second a type error appears. How to solve the error?

import pandas as pd

import numpy as np

import spacy

from spacy.cli.download import download


task_df = pd.read_excel(r'/content/Task Ratings.xlsx')


list_task_id = list(set(task_df['Task ID']))


nlp = spacy.load('en_core_web_sm')

doc = nlp(u'Use geospatial technology to develop soil sampling grids or identify sampling sites for testing characteristics such as nitrogen, phosphorus, or potassium content, ph, or micronutrients.') 
for sent in doc.sents:
  print([w.text for w in sent if w.dep_ == 'ROOT' or w.dep_ == 'pobj'])

patent_df = pd.read_excel(r'/content/Espacenet_IOT.xlsx')


"TypeError                                 Traceback (most recent call last)
    /usr/local/lib/python3.7/dist-packages/openpyxl/descriptors/base.py in _convert(expected_type, value)
         54         try:
    ---> 55             value = expected_type(value)
         56         except:
    TypeError: Fill() takes no arguments
    During handling of the above exception, another exception occurred:
    TypeError                                 Traceback (most recent call last)
    15 frames
    /usr/local/lib/python3.7/dist-packages/openpyxl/descriptors/base.py in _convert(expected_type, value)
         55             value = expected_type(value)
         56         except:
    ---> 57             raise TypeError('expected ' + str(expected_type))
         58     return value
    TypeError: expected <class 'openpyxl.styles.fills.Fill'>"```

Hi @CalosPB -

I see you have a couple of threads open with questions about Spacy. Are you using KNIME at all, or just looking for help with your Python code?


I don’t see any database but for excel you should check stackoverflow
sth like that

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.