![pypi](https://camo.githubusercontent.com/055fcc55e4cfa9ad868a95719332ac51b10edf6355e93f4ee05b45646677b506/68747470733a2f2f696d672e736869656c64732e696f2f707970692f762f416666792d45544c3f7374796c653d666f722d7468652d6261646765)
Easy to extract, transform and loading AffyData to MySQL
install.package("BiocManager")
BiocManager::install("affy")
BiocManager::install("affyio")
- The annotation data (cdf)
1.Extract
- Choose the file path of microarray data(.CEL)
- Choose the annotation of microarray platform(cdf)
from Affy_ETL import AETL
data, data_len = AETL.extract(dir="Your CEL dir",cdf="Your cdf name")
transform_data = AETL.transform(data, data_len)
AETL.loading(user="****", passwd="****", address="Your database Ip", dbname="****", tablename="****", data = transform_data)