My Tech Blog (컬럼)

Sensor1_X:66,Sensor1_Y:69,Sensor1_Z:61,Sensor2_X:-14,Sensor2_Y:20,Sensor2_Z:-20….(중략)>이런 게 계속 반복됨 , 기준으로 데이터 나누려고 함. data = "Sensor1_X:70,Sensor1_Y:53,Sensor1_Z:73,Sensor2_X:1,Sensor2_Y:1,Sensor2_Z:1" # 예시 데이터# ','로 데이터를 나눔sensor_data = data.split(',')# ':'로 다시 나누어서 각각의 센서 값 추출sensor_dict = {}for sensor in sensor_data: sensor_name, value = sensor.split(':') sensor_dict[sensor_name] = int(..

쿼리1SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(B.REVIEW_SCORE),2) AS SCOREFROM REST_INFO A INNER JOIN REST_REVIEW B ON A.REST_ID = B.REST_IDGROUP BY B.REST_IDHAVING A.ADDRESS LIKE '서울%'ORDER BY SCORE DESC, A.FAVORITES DESC 쿼리 2SELECT A.REST_ID, B.REST_NAME, B.FOOD_TYPE, B.FAVORITES, B.ADDRESS, ROUND(AVG(A.REVIEW_SCORE),2) AS SCOREFROM REST_REVIEW AJOIN REST_INFO..