
Advertisement
How do you like the idea of NOT saying " Oh I forgot, let me get back to you. "

Advertisement
INVBAT.COM - AI revolutionizing education and how to remember using augmented intelligence.
Try typing or saying I need the quadratic formula
Try typing or saying get me the quadratic formula
Try typing or saying show me the quadratic formula
ASK WHAT YOU NEED. TRY I NEED QUADRATIC EQUATION
AI Natural Language Query makes one click search now possible
Enter your access code above or ask what you need
INVBAT.COM - A.I. + CHATBOT voice search for formula , calculator, reviewer, work procedure and frequently asked questions (FAQ). It is useful immediately and on demand using your smartphone, notebook, tablet, laptop or desktop computer. Helping you to learn faster and 98% never forget.
INVBAT.COM - AI + CHATBOT is a personalized natural language search and information retrieval augmented intelligence service provider. We deliver immediate usefulness at affordable cost to our subscriber such as students, teachers, parents, and employees to help them remember what they stored in the cloud in one or fewer click using their smartphone, tablet, laptop, desktop computer, and smart tv.

Advertising rate $375 per year
Additional bonus if your school , community college, and university advertise, all your students and teachers will get free personal memory assistant chatbot for one month.
Advertise on this webpage. Use PayPal
After payment e-mail admin@invbat.com your advertising website link or your You Tube link and we will insert them on this webpage.
# Author : Apolinario (Sam) Ortega - founder of invbat.com-A.I + chatbot <admin@invbat.com)
# Date created: 6/13/2020
# license : BSD 3 clause
# Citation: kaggle.com for Ames Housing datasets
# comment : Show me how to do analysis for Ames Housing datasets with 82 columns
# comment : Show me the first five rows of record the Ames Housing datasets has using .info() function
import pandas as pd
import numpy as np
ames_housing = pd.read_excel('/Users/invbat/projects/ameshousing.xlsx')
ames_housing.head()
# comment # Do shift + enter
# comment : Now , show me the last five records using .tail() function
ames_housing.tail()
# comment # Do shift + enter
# comment: Now,show me the table or data set information summary using .info() function
ames_housing.info()
# comment # Do shift + enter
# comment : Using the table information summary you can see quickly how many missing data for each fieldname or column
print('')
print('Alley fieldname has missing value of 2930 - 198 =')
2930-198
# Comment: Now, show me missing value or NaN (Not a Number) information for whole data set using .isna() function
# comment: is the data not available? abbreviated as .isna = False if the data is available and True if not available.
ames_housing.isna()
# comment # Do shift + enter
# comment : How many rows of data in Alley fieldname or column name are missing ?
# alley_missingValue = ames_housing["Alley"]
print('')
print('Alley Missing Value is 2930 - 198 = 2732')
alley_missingValue = ames_housing["Alley"]
alley_missingValue
# comment # Do shift + enter
# comment: I want the count of non missing missing row for all Ames Housing data set using .count() function
print('')
print('Count of available data for each column = ' )
ames_housing.count()
# comment # Do shift + enter
# comment : show me how to use the .shape method in Ames Housing data set
# comment : If I ask you how many records of data and how many columns the Ames Housing data set has? What is the best
# way to get the answer ? Answer you can use .shape . shape returns the tuple (now called rows of data , number of columns)
# You can also .info() function but it listed all fieldnames
print('')
print('Ames Housing Table has 2930 rows of data , 82 columns of fieldname ' )
ames_housing.shape
# comment # Do shift + enter
# comment : show me how to use the .size method in Ames Housing data set
# comment : If I ask you how many records meaning rows x columns the Ames Housing data set has? What is the best
# way to get the answer ? Answer you can use .size - size returns the product of rows multiply by columns
print('')
print('Ames Housing Table size has 2930 rows x 82 columns = 240,260 data cells ' )
ames_housing.size
# comment # Do shift + enter
# comment : show me how to use the .columns method in Ames Housing data set
# comment : If I ask you list all the names of columns (also called dimension or features) the Ames Housing data set has?
# What is the best way to get the answer ? Answer you can use .columns - returns the list of all columns
print('')
print('Ames Housing Table has 82 columns also called field, features, or dimension ' )
ames_housing.columns
# comment # Do shift + enter
# comment : show me how to use the .index method in Ames Housing data set
# comment : If I ask you list all the names of columns (also called dimension or features) the Ames Housing data set has?
# What is the best way to get the answer ? Answer you can use .columns - returns the list of all columns
print('')
print('Ames Housing Table has total row record of 2,930 ' )
ames_housing.index
# comment # Do shift + enter
# comment : show me how to use the .select_dtypes method in Ames Housing data set
# comment : I want to review how many counts of columns have 'object' , dtypes : answer = 43 columns
print('')
print('Ames Housing Table has 43 "object" dtypes ' )
ames_housing.select_dtypes(include='object')
# comment # Do shift + enter
# comment : this count of object dtypes total was reported by default using .info()
# comment : show me how to use the .select_dtypes method in Ames Housing data set
# comment : I want to review how many counts of columns have 'int64' , dtypes : answer = 28 columns
# comment : I want the list of fieldname or column with 'int64' dtypes.
print('')
print('Ames Housing Table has 28 "int64" dtypes ' )
ames_housing.select_dtypes(include='int64')
# comment # Do shift + enter
# comment : this count of int64 dtypes total was reported by default using .info()
# comment : show me how to use the .select_dtypes method in Ames Housing data set
# comment : I want to review how many counts of columns have 'float64' , dtypes : answer = 11 columns
# comment : I want the list of fieldname or column with 'int64' dtypes.
print('')
print('Ames Housing Table has 11 "float64" dtypes ' )
ames_housing.select_dtypes(include='float64')
# comment # Do shift + enter
# comment : this count of float64 dtypes total was reported by default using .info()
# comment : show me how to use the .memory_usage method in Ames Housing data set
# comment : I want to review how many counts of columns have 'float64' , dtypes : answer = 11 columns
# comment : I want the list of fieldname or column with 'int64' dtypes.
print('')
print('Ames Housing memory usage of each column in bytes measurement, the total byte size = 1.8 MB + ' )
ames_housing.memory_usage()
# comment # Do shift + enter
# comment : the total memory usage for all columns was reported by default using .info()
# comment : So if you are ask what is total memory storage usage of the Ames Housing database. Answer use .info() function
INVBAT.COM - A.I. is a disruptive innovation in computing and web search technology. For example scientific calculator help us speed up calculation but we still need to remember accurately the formula and the correct sequence of data entry. Here comes the disruptive innovation from INVBAT.COM-A.I. , today the problem of remembering formula and the correct sequence of data entry is now solved by combining formula and calculation and make it on demand using smartphone, tablet, notebook, Chromebook, laptop, desktop, school smartboard and company big screen tv in conference room with internet connection.
For web search , INVBAT.COM-A.I, is demonstrating that you can type text or use voice to text A.I. to search the web and get direct answer in one or two clicks. You don't need to waste your time looking from million of search results.