iamaziz / etl

simple ETL example

Hi there 👋

Projects overview

Project Name	Description	URL	Comment
PyDataset	Instant access to many datasets in Python	Link
TermFeed	A simple terminal feed reader	Link
ar-embeddings	Sentiment Analysis for Arabic Text (tweets, reviews, and standard Arabic) using word2vec	Link
language-detection-fastText	Building a language detection classifier using fastText	Link
PyTorch-docset	PyTorch docset to use with Dash, Zeal, Velocity, or LovelyDocs	Link
iversions	A simple IPython/Jupyter cell magic command to display name and version of imported modules	Link
sqlify	Repository with 1 star and is licensed under MIT License	Link
SnowChat	Repository is tagged with snowflake, data-analysis, auto-code-generator, streamlit-application, gpt-4	Link
DataScope	Repository is marked as "Just For Fun"	Link
code_reader	Another "Just For Fun" repository, it is a streamlit-application	Link
us_patent	Repository is tagged with kaggle-competition, streamlit-application, huggingface-spaces	Link
bs4-dash	BeautifulSoup 4 docset for Dash	Link
iamaziz.github.io	A testing blog	Link
YouTube_downloader_app	Repository links to a YouTube downloader on huggingface.co	Link
lookml_visualizer	Visualize LookML contents as a network diagram in an interactive Plotly figure	Link
henry	A forked command line tool for Looker instance cleanup	Link
prophet	A forked tool for producing high quality forecasts for time series data that has multiple seasonality with linear or non-linear growth	Link
etl	A simple ETL example	Link
ar_wordcloud	A fork of WordCloud for Arabic	Link
oud_animator	Animate musical notes on the Arabic Oud strings (for fun and learning purpose)	Link
kge_qa	Simple-Question Answering based on Knowledge Graph Embeddings	Link
notebooky	Random ipython notebook scripts	Link
soccer-leagues-interactive	Visualization of the European Soccer Leagues standing tables	Link
queue-system	Simulating patients data flow in and out of a hospital	Link
pygraph	Create simple and quick Directed Graphs from relational statements	Link
algorithms-visualization-with-dash	Dash docset for algorithms-visualization repo	Link

Gists

etl's Issues

error

Data Pipeline created
extracting data from source ....
formatting and transforming data ...
Traceback (most recent call last):
File "pipeline.py", line 105, in
pipeline.transform()
File "pipeline.py", line 46, in transform
unemployment = self.unemployment[unemp_idx + unemp_cols].copy()
File "C:\Users\dell\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\core\frame.py", line 2133, in getitem
return self._getitem_array(key)
File "C:\Users\dell\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\core\frame.py", line 2177, in _getitem_array
indexer = self.loc._convert_to_indexer(key, axis=1)
File "C:\Users\dell\AppData\Local\Programs\Python\Python36-32\lib\site-packages\pandas\core\indexing.py", line 1269, in _convert_to_indexer
.format(mask=objarr[mask]))
KeyError: "['State' 'Area_name'] not in index"