Monday 31 December 2018

AWS AMAZON COMPREHEND INTRODUCTION





AWS AMAZON COMPREHEND INTRODUCTION



#dwbiadda #aws #comprehend

WHAT IS SPLUNK AND INTRODUCTION OF SPLUNK





WHAT IS SPLUNK AND INTRODUCTION OF SPLUNK



#dwbiadda #splunk #tutorial

Sunday 30 December 2018

Saturday 29 December 2018

Friday 28 December 2018

Wednesday 26 December 2018

Tuesday 25 December 2018

HANDLE NULL VALUES IN ORACLE USING NVL FUNCTION





HANDLE NULL VALUES IN ORACLE USING NVL FUNCTION



#dwbiadda #oracle #beginners #tutorial

Monday 24 December 2018

Sunday 23 December 2018

CREATING GOOGLE STORAGE BUCKET USING TERRAFORM







CREATING GOOGLE STORAGE BUCKET USING TERRAFORM



#dwbiadda #terraform #google #infrastructure

Tuesday 18 December 2018

Monday 17 December 2018

Sunday 16 December 2018

BUILD INFRASTRUCTURE USING TERRAFORM ON GOOGLE CLOUD PLATFORM





BUILD INFRASTRUCTURE USING TERRAFORM ON GOOGLE CLOUD PLATFORM



#dwbiadda #terraform #infrastructure #gcp

BUILD INFRASTRUCTURE USING TERRAFORM ON GOOGLE CLOUD PLATFORM





BUILD INFRASTRUCTURE USING TERRAFORM ON GOOGLE CLOUD PLATFORM



#dwbiadda #terraform #gcp #indrastructure

Saturday 15 December 2018

Friday 14 December 2018

Wednesday 12 December 2018

INSTALLING TERRAFORM ON GOOGLE CLOUD PLATFORM





INSTALLING TERRAFORM ON GOOGLE CLOUD PLATFORM



#dwbiadda #terraform #gcp #cloud #installation

HOW TO IMPLEMENT FIZZBIZZ PROBLEM IN JAVA





HOW TO IMPLEMENT FIZZBIZZ PROBLEM IN JAVA USING SINGLE VARIABLE



#dwbiadda #java #lab #exercises #interviewquestion

Tuesday 11 December 2018

Monday 10 December 2018

Sunday 9 December 2018

HOW TO KNOW WORD COUNT AND SENTENCES IN A FILE USING JAVA





HOW TO KNOW WORD COUNT AND SENTENCES IN A FILE USING JAVA



#dwbiadda #java #lab #exercises #wordcount #sentences

Saturday 8 December 2018

Friday 7 December 2018

Thursday 6 December 2018

HOW TO APPEND DATA TO A FILE IN LINUX





HOW TO APPEND DATA TO A FILE IN LINUX



#dwbiadda #linux #unix #videos #tutorial

Wednesday 5 December 2018

Tuesday 4 December 2018

HOW TO SWAP TWO NUMBERS WITHOUT THIRD VARIABLE IN JAVA





HOW TO SWAP TWO NUMBERS WITHOUT THIRD VARIABLE IN JAVA



#dwbiadda #swap #two #numbers #java

Monday 3 December 2018

HOW TO EXTRACT DAY NUMBERS FOR A PARTICULAR DAY IN A GIVEN PERIOD IN JAVA





HOW TO EXTRACT DAY NUMBERS FOR A PARTICULAR DAY IN A GIVEN PERIOD IN JAVA



#dwbiadda #java #lab #exercises

Sunday 2 December 2018

EMP TABLE INTRODUCTION IN SCOTT SCHEMA





EMP TABLE INTRODUCTION IN SCOTT SCHEMA



#dwbiadda #scott #emp #oracle #sql

HOW TO GENERATE LEAP YEAR IN JAVA FOR A GIVEN PERIOD







HOW TO GENERATE LEAP YEAR IN JAVA FOR A GIVEN PERIOD



#dwbiadda #java #lab #exercises #leapyear

Saturday 1 December 2018

HOW TO CREATE FILES IN LINUX USING CAT AND ECHO IN LINUX





HOW TO CREATE FILES IN LINUX USING CAT AND ECHO IN LINUX



#dwbiadda #unix #linux #cat #echo

HOW TO CHECK WHETHER THE GIVEN INPUT NUMBER IS PALINDROME IN JAVA





HOW TO CHECK WHETHER THE GIVEN INPUT NUMBER IS PALINDROME IN JAVA



#dwbiadda #java #fresher #videos #lab #exercises

Thursday 29 November 2018

Wednesday 28 November 2018

Tuesday 27 November 2018

Monday 26 November 2018

HOW TO IMPLEMENT FLOYD TRIANGLE IN JAVA





HOW TO IMPLEMENT FLOYD TRIANGLE IN JAVA



Freshers interview  questions exercises



#dwbiadda #floydtriangle #java

Friday 23 November 2018

Wednesday 21 November 2018

SETTING UP LINUX ENVIRONMENT IN GOOGLE CLOUD







SETTING UP LINUX ENVIRONMENT IN GOOGLE CLOUD PLATFORM



#unix #linux #dwbiadda #tutorial

HOW TO RUN APACHE SPARK JOB ON GOOGLE CLOUD PLATFORM





HOW TO RUN APACHE SPARK JOB ON GOOGLE CLOUD PLATFORM



#apachespark #googlecloud #dwbiadda

Monday 19 November 2018

Sunday 18 November 2018

Saturday 17 November 2018

HOW TO CREATE DATAPROC CLUSTER IN GOOGLE CLOUD





HOW TO CREATE DATAPROC CLUSTER IN GOOGLE CLOUD



#dwbiadda #dataproc #cluster #googlecloud

Friday 16 November 2018

Setting Up Oracle Database Environment





Setting Up Oracle Database Environment



#oracle #dwbiadda #installation #database

START WITH HIVE ON GOOGLE CLOUD SERVICES USING DATAPROC





START WITH HIVE ON GOOGLE CLOUD SERVICES USING DATAPROC

#dwbiadda #googlecloud #hive #dataproc #bucket

Tuesday 13 November 2018

SSH INTO VM USING WINDOWS PUTTY IN GOOGLE CLOUD





SSH INTO VM USING WINDOWS PUTTY IN GOOGLE CLOUD



#dwbiadda #googlecloud #ssh #putty #VM

Sunday 11 November 2018

HOW TO CREATE VIRTUAL MACHINE IN GOOGLE CLOUD USING COMMAND LINE





HOW TO CREATE VIRTUAL MACHINE IN GOOGLE CLOUD USING COMMAND LINE



#dwbiadda #virtualmachine #googlecloud

Saturday 10 November 2018

HOW TO COMPARE FACES USING AWS REKOGNITION





HOW TO COMPARE FACES USING AWS REKOGNITION



#DWBIADDA #AWSREKOGNITION #MACHINELEARNING

Friday 9 November 2018

HOW TO CREATE VIRTUAL MACHINE IN GOOGLE CLOUD WEB CONSOLE





HOW TO CREATE VIRTUAL MACHINE IN GOOGLE CLOUD WEB CONSOLE



#dwbiadda #virtualmachine #googlecloud

Tuesday 6 November 2018

Monday 5 November 2018

WHAT IS AWS REKOGNITION





WHAT IS AWS REKOGNITION HOW IS IT RELATES TO MACHINE LEARNING IN AWS



#DWBIADDA #AWSREKOGNITION #MACHINELEARNING

Thursday 1 November 2018

HOW TO READ FILTER CLEAN UP LOGGING IN GOOGLE STACK DRIVER





HOW TO READ FILTER CLEAN UP LOGGING IN GOOGLE STACK DRIVER



#dwbiadda #googlestackdriver #googlecloud

Wednesday 31 October 2018

WHAT IS GOOGLE STACK DRIVER LOGGING





WHAT IS GOOGLE STACK DRIVER LOGGING



#dwbiadda #googlestackdriverlogging #stackdriver

Tuesday 30 October 2018

Monday 29 October 2018

WHAT IS GOOGLE STOCK DRIVER LOGGING





WHAT IS GOOGLE STOCK DRIVER LOGGING



#dwbiadda #googlestockdriverlogging #stockdriver

Sunday 28 October 2018

HOW TO CREATE GOOGLE CLOUD STORAGE TRIGGERS





HOW TO CREATE GOOGLE CLOUD STORAGE TRIGGERS



#dwbiadda #googlecloud #storagetriggers

Saturday 27 October 2018

HOW TO CREATE GOOGLE CLOUD FUNCTION

#dwbiadda #googlecloudfunction #cloudfunction

https://youtu.be/pas33tRB4vQ


https://youtu.be/pas33tRB4vQ


Friday 26 October 2018

Thursday 25 October 2018

HOW TO CREATE A TABLE USING OTHER TABLE AND CLONE TABLE IN SNOWFLAKE





HOW TO CREATE A TABLE USING OTHER TABLE AND CLONE TABLE IN SNOWFLAKE



#snowflake #datawarehouse #dwbiadda

Tuesday 23 October 2018

Monday 22 October 2018

Sunday 21 October 2018

Saturday 20 October 2018

AWS GLUE CONSOLE OVERVIEW





AWS GLUE CONSOLE OVERVIEW



#dwbiadda #awsglue #awsglueconsole #awsglueetl

HOW TO INSTALL APACHE KAFKA IN GOOGLE CLOUD





HOW TO INSTALL APACHE KAFKA IN GOOGLE CLOUD



#dwbiadda #apachekafka #googlecloud

Friday 19 October 2018

Monday 8 October 2018

HOW TO APPLY SENTIMENT ANALYSIS USING LIVE TWITTER DATA





HOW TO APPLY SENTIMENT ANALYSIS USING LIVE TWITTER DATA



#dwbiadda #sentimentanalysis #twitter #python

Saturday 6 October 2018

HOW TO READ DATA FROM GITHUB URL





HOW TO READ DATA FROM GITHUB URL USING PYTHON PACKAGES



#PYTHON #PANDAS #IO #STRING #DWBIADDA

Friday 5 October 2018

WHAT IS GOOGLE CLOUD IAM AND HOW TO ASSIGN ROLES TO USERS





WHAT IS GOOGLE CLOUD IAM AND HOW TO ASSIGN ROLES TO USERS



#googlecloudiam #iam #dwbiadda #identityaccessmanagement

HOW TO READ MULTIPLE FILES USING PYTHON PANDAS





HOW TO READ MULTIPLE FILES USING PYTHON PANDAS



#python #pandas #readmultiplefiles #dwbiadda

HOW TO READ MULTIPLE FILES USING PYTHON PANDAS





HOW TO READ MULTIPLE FILES USING PYTHON PANDAS



#python #pandas #readmultiplefiles #dwbiadda

Monday 1 October 2018

HOW TO LOAD DATA INTO GOOGLE BIG QUERY FROM PYTHON PANDAS





HOW TO LOAD DATA INTO GOOGLE BIG QUERY FROM PYTHON PANDAS WITH SINGLE LINE OF CODE



#dwbiadda #googlebigquery #loaddata #pandas #python

Sunday 30 September 2018

HOW TO READ DATA FROM GOOGLE BIG QUERY TO PANDAS WITH SINGLE LINE OF CODE
#dwbiadda #bigquery #googlecloud #pandas

Saturday 29 September 2018

HOW TO INSTALL QLIKVIEW IN GOOGLE CLOUD

#dwbiadda #qlikview #googlecloud


Friday 28 September 2018

Thursday 27 September 2018

WHAT IS GOOGLE CLOUD SPANNER



WHAT IS GOOGLE CLOUD SPANNER



#googlecloudspanner #cloudspanner #dwbiadda


Wednesday 26 September 2018

APPLY JOINS INNER LEFT RIGHT OUTER WITH PYTHON PANDAS





APPLY JOINS INNER LEFT RIGHT OUTER WITH PYTHON PANDAS



#python #pandas #join #inner #left #right #outer

Tuesday 25 September 2018

APPLY UNION AND UNION ALL WITH PYTHON PANDAS





APPLY UNION AND UNION ALL WITH PYTHON PANDAS



#dwbiadda #pythonpandas #union #unionall

GOOGLE CLOUD DATA STORE FEATURES





GOOGLE CLOUD DATA STORE FEATURES



#dwbiadda #googlecloud #clouddatastore #googleclouddatastore

Monday 24 September 2018

Saturday 22 September 2018

PYTHON BASIC SENTIMENT ANALYSIS USING ALEXA DATA





Basic sentiment analysis using python pandas



#python #pandas #dwbiadda #analysis #repeatedwords



import pandas as pd

alexa_data=pd.read_csv('C:\Data_Set\conv_data\Alexa_rating.csv')

alexa_data.head(6)

alexa_data['desc_conver'] = alexa_data.verified_reviews.str.lower().str.strip().str.split()

alexa_data.head()



stop_words = frozenset(['the', 'as', 'is','i','it','to','and','my','this','for','have','a','but','of','on','in','that','was','so','can','you'])

conv_list_reviews = list()

for data in alexa_data[['variation', 'desc_conver']].iterrows() :

    row_data = data[1]

    for final_word in row_data.desc_conver:

        if final_word not in stop_words:

            conv_list_reviews.append((row_data.variation, final_word))





verified_reviews = pd.DataFrame(conv_list_reviews, columns=['produc_type', 'Repeated_word'])

data_set=verified_reviews[verified_reviews.Repeated_word.str.len()>0]



data_set=data_set.groupby('produc_type').Repeated_word.value_counts().to_frame().rename(columns={'Repeated_word':'Cnt_of_word'})

data_set.head()



def display_top_rec(records, index_lvl=0):

    final_result = records.groupby(level=index_lvl).apply(lambda records: records.nlargest(3,keep='first')).reset_index(level=index_lvl, drop=True)

    return final_result.to_frame()





display_top_rec(data_set['Cnt_of_word'])

Thursday 20 September 2018

Wednesday 19 September 2018

HOW TO LOAD GOOGLE BIG TABLE DATA TO BIG QUERY



HOW TO LOAD GOOGLE BIG TABLE DATA TO BIG QUERY



#dwbiadda #bigquery #bigtable #googlecloud

Tuesday 18 September 2018

GOOGLE CLOUD STORAGE TRNSFER SCHEDULE





GOOGLE CLOUD STORAGE TRNSFER SCHEDULE


#dwbiadd #googlecloud #googlecloudstorage #googlecloudstorageschedule

Monday 17 September 2018

TRANSFER AWS DATA FILES TO GOOGLE CLOUD



TRANSFER AWS DATA FILES TO GOOGLE CLOUD



#dwbiadda #awstogooglecloudtransfer #googlecloud #aws

Sunday 16 September 2018

PREDICTING DATA USING DATE RANGE METHOD IN PYTHON PANDAS



PREDICTING DATA USING DATE RANGE METHOD IN PYTHON PANDAS



#dwbiadda #dataprediction #pythonpandas

GOOGLE CLOUD STORAGE USING SHELL





This video explains how to load files or images into google cloud using gshell



#dwbiadda #googlecloudtrainingvideos #bucket #shell

Saturday 15 September 2018

GOOGLE CLOUD STORAGE AND IMPORTING FILES USING WEB





google cloud storage files or images using web interface



#dwbiadda #googlecloudstorage #webinterface #filestorage #cloud

Friday 14 September 2018

PREDICTING MISSING DATA USING PYTHON PANDAS PART 1



Predicting missing data using python pandas



#pandas #dwbiadda #prediction #machinelearning

Wednesday 12 September 2018

PYTHON PANDAS REPLACING NULL VALUES USING FILLNA METHOD





python pandas replacing null values using fillna method



#dwbiadda #pythonpandas #pandas #training #fillna

Loading parquet data into Google big query







This video explains how to load Paraquet data into google cloud big query



#googlecloud #bigquery #dwbidda #paraquet

Odi 12c free training session1





#oracle #dwbiadda #oracleodi oracle odi online training videos

Tuesday 11 September 2018

Loading Apache Avro data into Google big query





Loading Apache Avro data into Google cloud big query


#dwbiadda #apacheavro #googlecloud #bigquery