User:Rdhill734455/sandbox

About This Guide
This is the Eric 6 User's Guide. Its goal is help users learn about Eric 6, an integrated development environment (IDE) for Python. It contains detailed information about Eric’s main features, tools and benefits and demonstrates them through some typical use-cases.

The guide will probably be most useful to those with some Python experience who are new, occasional or basic users of Eric. Although it may turn into it, the guide is not currently intended to be comprehensive documentation of Eric’s every feature; rather, it focuses on the most popular, useful and powerful ones. It supplements the information available in the Technical Report prepared by Pietro Moras.

The Eric 6 User’s Guide is under development. It is being built by a group of grateful Eric users. You can help by joining in. There are several ways to do that. You can join WikiBooks as a writer/editor and contribute your own content.

Organization

 * 1) Getting Started
 * 2) * Installation
 * 3) * Upgrading
 * 4) * Quick Start
 * 5) * UI Tour
 * 6) Eric as a Quick-And-Dirty Editor/Debugger
 * 7) GUI Development
 * 8) Settings
 * 9) Tools

Main Page

WikiBooks Help:Contents

Eric 6 User's Guide/Eric As a Quick-And-Dirty Python Editor

Scenario
You want to import some data into a database. To do so, you need to manipulate some of the text for consistency, turning text like this:
 * Province/State,Country/Region,Last Update,Confirmed,Deaths,Recovered
 * Anhui,Mainland China,1/22/2020 17:00,1,,
 * Beijing,Mainland China,1/22/2020 17:00,14,,

and this:


 * Province/State,Country/Region,Last Update,Confirmed,Deaths,Recovered,Latitude,Longitude
 * Hubei,Mainland China,2020-03-03T11:43:02,67217,2835,36208,30.9756,112.2707
 * ,South Korea,2020-03-03T09:43:02,5186,28,30,36.0000,128.0000
 * ,Italy,2020-03-03T20:03:06,2502,79,160,43.0000,12.0000
 * ,Iran,2020-03-03T14:23:03,2336,77,291,32.0000,53.0000
 * Guangdong,Mainland China,2020-03-03T10:23:10,1350,7,1101,23.3417,113.4244

and this:


 * FIPS,Admin2,Province_State,Country_Region,Last_Update,Lat,Long_,Confirmed,Deaths,Recovered,Active,Combined_Key
 * 45001,Abbeville,South Carolina,US,2020-04-10 22:54:07,34.22333378,-82.46170658,7,0,0,0,"Abbeville, South Carolina, US"
 * 22001,Acadia,Louisiana,US,2020-04-10 22:54:07,30.295064899999996,-92.41419698,94,4,0,0,"Acadia, Louisiana, US"
 * 51001,Accomack,Virginia,US,2020-04-10 22:54:07,37.76707161,-75.63234615,12,0,0,0,"Accomack, Virginia, US"

into this:
 * Rpt_Date,Confirmed,Deaths,Recovered,Combined_Key
 * "2020-05-18",35,0,0,"Abbeville, South Carolina, US"
 * "2020-05-18",198,12,0,"Acadia, Louisiana, US"
 * "2020-05-18",688,9,0,"Accomack, Virginia, US"
 * "2020-05-18",773,22,0,"Ada, Idaho, US"
 * "2020-05-18",5,0,0,"Adair, Iowa, US"

A perfect project for Python and Eric. This will be a console-only application – no need for classes or a fancy GUI just to clean up some text files.

Background
Suppose you have an interest in Covid-19 data and find the publicly available representations of that data to be too narrow and limiting. You see that news organizations are crediting the Center for Systems Science and Engineering at Johns Hopkins University (JHU CSSE) as the data source. It turns out that JHU makes the data it collects publicly accessible on github: github.com/CSSEGISandData/COVID-19

Suppose further that you have access to a realtional database manaagement system (RDBMS) like MariaDB or Firebird and can work with it using a GUI tool like DBeaver.

Transform Plan
I probably should review the structure of Blender Noob to Pro re flat or deep structure.The recommendation is flat.

So that would be just the main chapter titles