Module my_autopylot.datascience39

Functions

def browser_get_html_tabular_data_from_website(website_url='', output_folder='')

Web Scrape HTML Tables : Gets Website Table Data Easily as an Excel using Pandas. Just pass the URL of Website having HTML Tables. If there are 5 tables on that HTML page and you want 4th table, pass table_index as 3

Ex: browser_get_html_tabular_data_from_website(website_url=URL)

def excel_describe_data(input_filepath='', input_sheetname='Sheet1', header=0)

Describe statistical data for the given excel

def excel_drag_drop_pivot_table(input_filepath='', input_sheetname='Sheet1', header=0, rows=[], cols=[])

Args

input_filepath : str, optional
[description]. Defaults to "".
sheet_name : str, optional
[description]. Defaults to "Sheet1".
header : int, optional
[description]. Defaults to 0.
rows : list, optional
[description]. Defaults to [].
cols : list, optional
[description]. Defaults to [].
def excel_draw_charts(input_filepath='', input_sheetname='Sheet1', header=0, x_col='', y_col='', chart_type='bar', title='PyBOTs Chart')

Interactive data visualization function, which accepts excel file, X & Y column. Chart types accepted are bar , scatter , pie , sun , histogram , box , strip. You can pass color column as well, having a boolean value. Image gets saved as .PNG in the same path as excel file.