阅读背景:

从json中创建的熊猫dataframe有一个未命名的列——由于未命名的列问题,无法插入到MySQL中

来源:互联网 

Right now I messing with some JSON data and I am trying to push it into the MySQL database on the fly. The JSON file is enormous so I have to carefully go through it line by line using yield function in Python, convert each JSON line into small pandas DF and write it into MySQL. The problem is that when I create DF from JSON it adds the index column. And it seems that when I write stuff to MySQL it ignores index=False option. Code belowRight now I messing with some JSON data and I a




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: