已解决mysql shell 中没有numpy & pandas module

最新推荐文章于 2024-05-03 18:41:34 发布

DB架构

最新推荐文章于 2024-05-03 18:41:34 发布

阅读量274

点赞数

分类专栏： Linux Data Science 文章标签： python 开发语言

本文链接：https://blog.csdn.net/u011868279/article/details/127323689

版权

Data Science 同时被 2 个专栏收录

61 篇文章 2 订阅

订阅专栏

Linux

43 篇文章 0 订阅

订阅专栏

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > \source /home/maxwell/datasets/mysql_shell/generate_patients_data.py
Traceback (most recent call last):
  File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'numpy'
Traceback (most recent call last):
  File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'pandas'

首先检查是否安装pandas & numpy，并且确认安装路径。

/home/maxwell/.local/lib/python3.9/site-packages

[maxwell@MaxwellDBA mysql_shell]$ pip install pandas
Defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: pandas in /home/maxwell/.local/lib/python3.9/site-packages (1.5.0)
Requirement already satisfied: numpy>=1.20.3 in /home/maxwell/.local/lib/python3.9/site-packages (from pandas) (1.23.4)
Requirement already satisfied: pytz>=2020.1 in /home/maxwell/.local/lib/python3.9/site-packages (from pandas) (2022.4)
Requirement already satisfied: python-dateutil>=2.8.1 in /home/maxwell/.local/lib/python3.9/site-packages (from pandas) (2.8.2)
Requirement already satisfied: six>=1.5 in /home/maxwell/.local/lib/python3.9/site-packages (from python-dateutil>=2.8.1->pandas) (1.16.0)
[maxwell@MaxwellDBA mysql_shell]$ pip install numpy
Defaulting to user installation because normal site-packages is not writeable
Requirement already satisfied: numpy in /home/maxwell/.local/lib/python3.9/site-packages (1.23.4)
[maxwell@MaxwellDBA mysql_shell]$

将此路径加入到系统路径中：

import sys
sys.path.append("/home/maxwell/.local/lib/python3.9/site-packages")

 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import sys
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > sys.path.append("/home/maxwell/.local/lib/python3.9/site-packages")
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > 
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import numpy as np
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py > import pandas as pd
 MySQL  127.0.0.1:33060+ ssl  cookbook  Py >