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

download(model=“en_core_web_sm”)



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

len(task_df)

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

len(list_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')

patent_df

"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
         59 
    
    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?

2 Likes

I don’t see any database but for excel you should check stackoverflow
sth like that
https://stackoverflow.com/questions/57759046/how-to-solve-the-problem-expected-class-openpyxl-styles-fills-fill-when

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