Skip to content

Commit f45a308

Browse files
committed
Added readme back to base repository
1 parent dae7ea4 commit f45a308

1 file changed

Lines changed: 33 additions & 0 deletions

File tree

‎readme.md‎

Lines changed: 33 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,33 @@
1+
# Basic-ETL
2+
3+
This is an example final project of a local ETL process. As an intro & undergrad
4+
class this does not include network operations that would typically be expected and this version does not include NoSQL systems. It starts with building Tests (TDD) and then progresses through:
5+
- Checking a directory for files
6+
- Processing the files in the directory based on their extension
7+
- This example includes a parallel processing option (this was not required)
8+
- Standard Parsing (remove empty lines and performs basic validation)
9+
- Text Files include very basic NLP operation (nGram & regex matching)
10+
- Loads data to an included SQLite database
11+
- This was used to explain the limitations of ACID for analysis
12+
- Seperate version with MongoDB is included in its own Repository
13+
- Performs standard SQL analysis (using aggregated functions and group by)
14+
- Performs Rule Based Analysis (Affinity Analysis and Proability of event)
15+
16+
This was used to show iterative software development (Agile & TDD) with
17+
Python and in a data engineering application. The project used to build the
18+
data (both the JSON & XML) is included in [JSG-Research-Methods](#addme).
19+
20+
## License
21+
22+
The content of any data used within projects
23+
themselves is licensed under the
24+
[Creative Commons Attribution 4.0 International license](https://creativecommons.org/licenses/by/4.0/) and has been entered by random answering of questions (its fake data).
25+
While the source code of any script or program
26+
is licensed under the [MIT license](LICENSE.md).
27+
28+
<small>
29+
30+
*All code was authored and written by Professor Greenwell (self) based on
31+
problems proposed in workbook.*
32+
33+
</small>

0 commit comments

Comments
 (0)