ExploringPandasAI.py

# This command will impute missing values in your data frame.
sdf.impute_missing_values()

# To ask your data questions using PandaAI, you use sdf.chat

sdf.chat("who is the ideal tenant for a 3 bedroom in kolkata")

sdf.chat("Return the top 5 expensive city by rent")

sdf.chat("In a table show me the average rent in the various cities each month and group this data by the BHK") #BHK here represent number of bedrooms, hall, and kitchen

sdf.chat("In a table show me the number of Point of Contact in the various cities each month and group this data by the Point of Contact")

# You can also generate charts with PandaAI;

sdf.chat("Plot a chart of the average rent by city")

sdf.plot_correlation_heatmap()

sdf.chat("Create a line chart to show the trend of rent  by city in the last few months")

sdf.chat("Calculate the average cost of rent in Delhi")