Hello,
Hope everyone is doing well. I am trying to plot dvv for individual station
pairs and am running into the problem of it coming up as an empty dataframe
(see attached screenshots), which in turn means nothing gets plotted for
the individual station pair and only the median and mean dvv gets plotted
(see attachment)
. I was wondering if anyone else had run into this issue before and knows
what to do or if there is something that I might have done wrong to cause
this issue. Thanks in …
[View More]advance! Have a great day![image: Screen Shot
2021-10-11 at 2.21.28 PM.png]
[image: plottingindvstatpair.png]
Best Wishes,
Michelle Lee
----------------------------------------------------------------------------
Graduate Student
Columbia University: Lamont-Doherty Earth Observatory
Department of Earth and Environmental Science
Marine Geology and Geophysics
c: (206)397-2488
alt. email: mkl2158(a)columbia.edu
[View Less]
Hello
I’m trying to install MSNoise, but keep getting unintelligible (to me) errors when running msnoise test:
*****
Traceback (most recent call last):
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/…
[View More]cursors.py", line 148, in execute
result = self._query(query)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
pymysql.err.ProgrammingError: (1146, "Table 'msnoise.config' doesn't exist")
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/anaconda3/bin/msnoise", line 5, in <module>
from msnoise.scripts.msnoise import run
File "/opt/anaconda3/lib/python3.8/site-packages/msnoise/scripts/msnoise.py", line 1183, in <module>
plugins = get_config(db, "plugins")
File "/opt/anaconda3/lib/python3.8/site-packages/msnoise/api.py", line 215, in get_config
config = session.query(table).filter(table.name == name).first()
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3429, in first
ret = list(self[0:1])
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3203, in __getitem__
return list(res)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3535, in __iter__
return self._execute_and_instances(context)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/orm/query.py", line 3560, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/opt/anaconda3/lib/python3.8/site-packages/sqlalchemy/engine/default.py", line 593, in do_execute
cursor.execute(statement, parameters)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line 148, in execute
result = self._query(query)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/cursors.py", line 310, in _query
conn.query(q)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 548, in query
self._affected_rows = self._read_query_result(unbuffered=unbuffered)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 775, in _read_query_result
result.read()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 1156, in read
first_packet = self.connection._read_packet()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/connections.py", line 725, in _read_packet
packet.raise_for_error()
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/protocol.py", line 221, in raise_for_error
err.raise_mysql_exception(self._data)
File "/opt/anaconda3/lib/python3.8/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
raise errorclass(errno, errval)
sqlalchemy.exc.ProgrammingError: (pymysql.err.ProgrammingError) (1146, "Table 'msnoise.config' doesn't exist")
[SQL: SELECT config.name AS config_name, config.value AS config_value
FROM config
WHERE config.name = %(name_1)s
LIMIT %(param_1)s]
[parameters: {'name_1': 'plugins', 'param_1': 1}]
(Background on this error at: http://sqlalche.me/e/13/f405)
*****
I’ve got all the required Python packages, MySQLServer and Workbench versions 8.0.18 (compatible with my macOS Mojave 10.14.6). Local database and user are set-up.
Any ideas?
Thanks,
Dave
David Healy [he/him]
School of Geosciences
Meston Walk
University of Aberdeen
Aberdeen AB24 3UE
My working day may not be your working day. Please do not feel obliged to reply to this e-mail outside of your normal working hours.
Publications: https://scholar.google.com/citations?hl=en&user=ug9DnVoAAAAJ
Software: http://www.fracturedrockphysics.com/software.html
Home page: http://www.fracturedrockphysics.com/index.html
The University of Aberdeen is a charity registered in Scotland, No SC013683.
Tha Oilthigh Obar Dheathain na charthannas clàraichte ann an Alba, Àir. SC013683.
[View Less]
