can you make this code send userid, gsrdata, emgdata, currenttime to a firebase database…
- User
can you make this code send user_id, gsr_data, emg_data, current_time to a firebase database
import serial import time import gspread from oauth2client.service_account import ServiceAccountCredentials from datetime import datetime import tensorflow.lite as lite import pandas as pd import numpy as np from sklearn.preprocessing import MinMaxScaler
user_id = "1"
Set up the serial connection to the Arduino Uno board
ser = serial.Serial('/dev/ttyACM0', 9600)
Set up credentials and connect to Google Sheets
scope = ['https://spreadsheets.google.com/feeds', 'https://www.googleapis.com/auth/drive'] creds = ServiceAccountCredentials.from_json_keyfile_name('/home/salvador/Downloads/credentials.json', scope) client = gspread.authorize(creds)
Open the sheet and get the new data
sheet1 = client.open("Projectdata").worksheet("Sheet1") training_data = pd.DataFrame(sheet1.get_all_records())
Get Sheet2 for appending the new data
sheet2 = client.open("Projectdata").worksheet("Sheet2")
Load the TensorFlow Lite model
interpreter = lite.Interpreter(model_path="/home/salvador/Downloads/model.tflite") interpreter.allocate_tensors()
Get input and output tensors
input_details = interpreter.get_input_details() output_details = interpreter.get_output_details()
Create a scaler and fit it to the training data
scaler = MinMaxScaler() scaler.fit(training_data[['GSRdata', 'EMGdata']])
while True: # Read the serial data line = ser.readline().decode().strip()
# Split the data into GSR and EMG values gsr_data, emg_data = map(int, line.split(',')) # Get the current time current_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S') # Preprocess the data and make a prediction input_data = np.array([gsr_data, emg_data], dtype=np.float32) input_data = scaler.transform(input_data.reshape(1, -1)) interpreter.set_tensor(input_details[0]['index'], input_data) interpreter.invoke() prediction = interpreter.get_tensor(output_details[0]['index']) predicted_label = np.argmax(prediction, axis=1) soreness_label = '' if predicted_label == 0: soreness_label = 'relaxed' elif predicted_label == 1: soreness_label = 'tense' elif predicted_label == 2: soreness_label = 'exhausted' else: print('Unknown category') # Create a row of data to append to the worksheet row = [user_id,gsr_data, emg_data, current_time,soreness_label] # Append the row to Sheet2 sheet2.append_row(row) print("UserID: " , user_id) print("GSR Data: " , gsr_data) print("EMG Data: " , emg_data) print("Time: " , current_time) print("Soreness: ", soreness_label) # Wait for 5 seconds before reading data again time.sleep(5) - Assistant
In order to send the user_id, gsr_data, emg_data, and current_time to a Firebase database, you just need to follow the instructions provided in the Firebase documentation to set up and initialize the Firebase SDK. Then, you can create a function that pushes the data to the Firebase database as new children nodes.
Here's the modified code to send the data to a Firebase database:
import serial import time import pandas as pd import numpy as np from sklearn.preprocessing import MinMaxScaler from datetime import datetime import tensorflow.lite as lite # To import Firebase dependencies import firebase_admin from firebase_admin import credentials from firebase_admin import db user_id = "1" # Initialize the Firebase SDK cred = credentials.Certificate("/path/to/firebase_service_account_key.json") firebase_admin.initialize_app(cred, { 'databaseURL': 'https://your-project-name.firebaseio.com/' }) # Get a reference to the Firebase database data_ref = db.reference('data') ser = serial.Serial('/dev/ttyACM0', 9600) # Load the TensorFlow Lite model interpreter = lite.Interpreter(model_path="/home/salvador/Downloads/model.tflite") interpreter.allocate_tensors() input_details = interpreter.get_input_details() output_details = interpreter.get_output_details() scaler = MinMaxScaler() scaler.fit(training_data[['GSRdata', 'EMGdata']]) while True: line = ser.readline().decode().strip() gsr_data, emg_data = map(int, line.split(',')) current_time = datetime.now().strftime('%Y-%m-%d %H:%M:%S') input_data = np.array([gsr_data, emg_data], dtype=np.float32) input_data = scaler.transform(input_data.reshape(1, -1)) interpreter.set_tensor(input_details[0]['index'], input_data) interpreter.invoke() prediction = interpreter.get_tensor(output_details[0]['index']) predicted_label = np.argmax(prediction, axis=1) soreness_label = '' if predicted_label == 0: soreness_label = 'relaxed' elif predicted_label == 1: soreness_label = 'tense' elif predicted_label == 2: soreness_label = 'exhausted' else: print('Unknown category') # Push the data to the Firebase database as a new child node data_ref.push({ 'user_id': user_id, 'gsr_data': gsr_data, 'emg_data': emg_data, 'current_time': current_time, 'soreness_label': soreness_label, }) print("UserID: ", user_id) print("GSR Data: ", gsr_data) print("EMG Data: ", emg_data) print("Time: ", current_time) print("Soreness: ", soreness_label) time.sleep(5)Replace
/path/to/firebase_service_account_key.json,https://your-project-name.firebaseio.com/, and the other file paths with the appropriate values for your Firebase and local environment.This code will send the user_id, gsr_data, emg_data, current_time, and soreness_label to the Firebase database every 5 seconds as new child nodes.