When using agg() and join() methods on pandas DataFrame, sometimes you will get two below errors: , and: These errors may be due to the NaN value in your columns. Let’s try to create these errors with the below script: You will find below errors: 1. Future Warning: 2. Type Error: Let’s fill NaN withContinue reading “TypeError: Sequence item 1: expected str instance, float found”
Category Archives: mysql
The total number of lock exceeds the lock table size in MySQL
Below error when using python with sqlalchemy module and MySQL MariaDB. Error: MySQL is trying to tell you that it doesn’t have enough room to store all of the row locks that it would need to execute your query. The only way to fix it for sure is to adjust innodb_buffer_pool_size and restart MySQL. By default, thisContinue reading “The total number of lock exceeds the lock table size in MySQL”
Software Technology 