<jupyter_start><jupyter_text>This is for debugging the code<jupyter_code>%load_ext autoreload
%autoreload 2
import matplotlib.pyplot as plt
%matplotlib inline
import numpy as np
import sys
np.set_printoptions(threshold=sys.maxsize)
from sys import path
path.append('..')
from solar_data_pipeline.database.cassandra import CassandraDataAccess
data_access = CassandraDataAccess("127.0.0.1")
sites = data_access.get_sites()
sites
site_1_data = data_access.retrieve(sites=['SLACA0000001'])
site_1_data
plt.imshow(site_1_data)
plt.plot(site_1_data[:,0])
plt.plot(site_1_data[:,1])
plt.plot(site_1_data[:,2])
plt.plot(site_1_data[:,3])
plt.plot(site_1_data[:,4])
plt.plot(site_1_data[:,5])
site_1_data.shape
input_power_signals_file_path = "../tests/fixtures/one_year_power_signals_1.csv"
with open(input_power_signals_file_path) as file:
    one_year_power_signals = np.loadtxt(file, delimiter=',')
power_signals_site_1 = one_year_power_signals[:, :6]
power_signals_site_1.shape
plt.imshow(power_signals_site_1)
plt.plot(power_signals_site_1[:,0])
plt.plot(power_signals_site_1[:,1])
plt.plot(power_signals_site_1[:,2])
plt.plot(power_signals_site_1[:,3])
plt.plot(power_signals_site_1[:,4])
plt.plot(power_signals_site_1[:,5])
(site_1_data[:,0] == power_signals_site_1[:,0]).all()
site_1_data[:,0][100] == power_signals_site_1[:,0][100]
site_1_data[:,0][100]
power_signals_site_1[:,0][100]<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.14770318021201415, 'fraction_numerical': 0.05017667844522968, 'mean_word_length': 10.60655737704918, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 1, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '430105', 'license': 'BSD-2-Clause', 'n_tokens_mistral': 605, 'n_tokens_neox': 589, 'n_words': 73, 'path': 'notebooks/Local Cassandra data trial.ipynb', 'repo_name': 'slacgismo/solar-data-pipeline', 'size': '1415'}