DHT11

#include "DHT.h"        // including the library of DHT11 temperature and humidity sensor
#define DHTTYPE DHT11   // DHT 11

#define dht_dpin 0
DHT dht(dht_dpin, DHTTYPE);
void setup(void)
{
  dht.begin();
  Serial.begin(9600);
  Serial.println("Humidity and temperature\n\n");
  delay(700);

}
void loop() {
    float h = dht.readHumidity();
    float t = dht.readTemperature();       
    Serial.print("Current humidity = ");
    Serial.print(h);
    Serial.print("%  ");
    Serial.print("temperature = ");
    Serial.print(t);
    Serial.println("C  ");
  delay(800);

}

P value in Python

import pandas as pd

import numpy as np

from sklearn import datasets, linear_model

from sklearn.linear_model import LinearRegression

import statsmodels.api as sm

from scipy import stats

diabetes = datasets.load_diabetes()

X = diabetes.data

y = diabetes.target

X2 = sm.add_constant(X)

est = sm.OLS(y, X2)

est2 = est.fit()

print(est2.summary())

Cube in Hive and SQL server

https://cwiki.apache.org/confluence/display/Hive/Enhanced+Aggregation%2C+Cube%2C+Grouping+and+Rollup



https://drive.google.com/file/d/1fA_rQx14FOKNM9lsDzZzmDqX4fx5iblw/view?usp=sharing

DW Lab1

CREATE TABLE IF NOT EXISTS vnr_table

(col1 int COMMENT 'col1',

col2 string,

col3 int,

col4 DECIMAL,

col5 int)

COMMENT 'This is test table'

ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE;

Desc vnr_table;

load data LOCAL INPATH '/home/cloudera/Desktop/movies_data.csv' OVERWRITE INTO TABLE vnr_table;

select * from vnr_table;