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.