I am trying to write a Pandas dataframe (or can use a numpy array) to a mysql database using MysqlDB . MysqlDB doesn’t seem understand ‘nan’ and my database throws out an error saying nan is not in the field list. I need to find a way to convert the ‘nan’ into a NoneType. Any … Read more
I am trying to get a Python script to run on the linux server I’m connected to via ssh. The script uses mysqldb. I have all the other components I need, but when I try to install mySQLdb via setuptools like so:, python setup.py install I get the following error report related to the mysql_config … Read more
This is the error I get (mysite)zjm1126@zjm1126-G41MT-S2:~/zjm_test/mysite$ pip install mysql-python Downloading/unpacking mysql-python Downloading MySQL-python-1.2.3.tar.gz (70Kb): 70Kb downloaded Running setup.py egg_info for package mysql-python sh: mysql_config: not found Traceback (most recent call last): File “<string>”, line 14, in <module> File “/home/zjm1126/zjm_test/mysite/build/mysql-python/setup.py”, line 15, in <module> metadata, options = get_config() File “setup_posix.py”, line 43, in get_config libs … Read more
I am trying to install version 1.2.2 of MySQL_python, using a fresh virtualenv created with the –no-site-packages option. The current version shown in PyPi is 1.2.3. Is there a way to install the older version? I have tried: pip install MySQL_python==1.2.2 However, when installed, it still shows MySQL_python-1.2.3-py2.6.egg-info in the site packages. Is this a … Read more
