{"id":104,"date":"2020-08-18T01:27:23","date_gmt":"2020-08-18T01:27:23","guid":{"rendered":"http:\/\/localhost\/dwbapps\/?page_id=104"},"modified":"2021-01-15T05:23:01","modified_gmt":"2021-01-15T05:23:01","slug":"screenshots","status":"publish","type":"page","link":"https:\/\/thedatapup.com\/home\/index.php\/data-pup\/screenshots\/","title":{"rendered":"Data Analysis with Data Pup"},"content":{"rendered":"\n

The following screens demonstrate the exploratory data analysis features of Datapup when using it in Python workspace mode.<\/p>\n\n\n\n

NOTE: The following guide uses data from data.gov.au and is licensed under Creative Commons Attribution<\/a>:
– Airport traffic data https:\/\/data.gov.au\/dataset\/ds-dga-cc5d888f-5850-47f3-815d-08289b22f5a8<\/a>
– NSW COVID-19 cases by age range https:\/\/data.gov.au\/dataset\/ds-nsw-3dc5dc39-40b4-4ee9-8ec6-2d862a916dcf<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n

First, create a python workspace, here called “example”. Specify a file where you will put your Python script code.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Click on DataFrames > Python Script, or click on the code button shown below to access the Python editor window:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

This window allows you to enter Python code that creates Pandas DataFrames. Any variable that is a dataframe will be available for querying. Here I load a csv file into the variable df_pax.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

DataFrames appear on the right.  Right click on one, and you can do standard EDA operations like correlations, data types and describe from the Python Pandas library. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Next, write your SQL directly in the SQL window, and execute using the Run button, or Ctrl-Enter or Shift-F9.  (Press Ctrl-H to see all shortcut keys).<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n


Right click on the results, or use the buttons on the right, to run commands such as correlation and describe on the output table. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Plots and counts<\/em><\/h2>\n\n\n\n

Right click on a column header in the results, to run commands such as box plots and scatter plots.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Here I’ve chosen Int_pax_in for the Y axis value.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Importing CSV using the GUI<\/h2>\n\n\n\n

Back to the main window, from the menu DataFrames > Import CSV, you can import CSV files without writing Python. Here I’ve given the DataFrame a name of covidnsw, and accepted defaults.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Data Pup has automatically updated the python script (since I left the update python script option checked)<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Back in the main window, add some additional SQL to query the new DataFrame covidnsw, and execute it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Right click on column age_group and choose value counts.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

The following screens demonstrate the exploratory data analysis features of Datapup when using it in Python workspace mode. NOTE: The following guide uses data from data.gov.au and is licensed under Creative Commons Attribution:– Airport traffic data https:\/\/data.gov.au\/dataset\/ds-dga-cc5d888f-5850-47f3-815d-08289b22f5a8– NSW COVID-19 cases by age range https:\/\/data.gov.au\/dataset\/ds-nsw-3dc5dc39-40b4-4ee9-8ec6-2d862a916dcf First, create a python workspace, here called “example”. Specify a file … <\/p>\n

Continue reading “Data Analysis with Data Pup”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":52,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/104"}],"collection":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/comments?post=104"}],"version-history":[{"count":5,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/104\/revisions"}],"predecessor-version":[{"id":518,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/104\/revisions\/518"}],"up":[{"embeddable":true,"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/pages\/52"}],"wp:attachment":[{"href":"https:\/\/thedatapup.com\/home\/index.php\/wp-json\/wp\/v2\/media?parent=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}