semvec/pypi-packages huggingface dataset:
GetGeneLength 0.0.4
Extract gene length based on featureCount calculation gene nonredundant exon length method.
Requires Python: >=3.6

# GetGeneLength Package

- Extract gene length based on featureCount calculation gene nonredundant exon length method.

- If you want to calculate TPM/FPKM/RPKM to visualize results and for other downstream analysis with only count matrix, you can use this **GetGeneLength** function to get gene length information and get normalized values.

## Install

```shell
$ pip install GetGeneLength
```

## Usage

help infomation:

```shell
$ GetGeneLength -h
usage: GetGeneLength --database ensembl --gtffile gencode.v38.annotation_human.gtf --lengthfile gene_length.txt

Get gene length from GTF annotation file.

optional arguments:
  -h, --help            show this help message and exit
  -v, --version         show program's version number and exit
  -d {ucsc,ensembl,gencode}, --database {ucsc,ensembl,gencode}
                        which annotation database you choose. (default="ensembl")
  -g GTFFILE, --gtffile GTFFILE
                        input your GTF file. (ucsc/ensembl/gencode)
  -l LENGTH_INFO, --lengthfile LENGTH_INFO
                        output your gene lenth file. (gene_length.txt)

Thank your for your support, if you have any questions or suggestions please contact me: 3219030654@stu.cpu.edu.cn.
```

for ucsc gtf file:

```shell
$ GetGeneLength -d ucsc -g hg38.ncbiRefSeq.gtf -l ucsc_gene_length.txt
Your job is running, please wait...

Your job is done!

$ head -n 3 ucsc_gene_length.txt
TRNP	TRNP	68
TRNT	TRNT	66
CYTB	CYTB	1141
```

for gencode/ensembl gtf file:

```shell
$ GetGeneLength -d gencode -g gencode.v38.annotation_human.gtf -l gene_length.txt
Your job is running, please wait...

Your job is done!

$ head -n 3 gene_length.txt
DDX11L1	ENSG00000223972.5	transcribed_unprocessed_pseudogene	1735
WASH7P	ENSG00000227232.5	unprocessed_pseudogene	1351
MIR6859-1	ENSG00000278267.1	miRNA	68
```
cakemix 0.0.12
Python library to open Office documents, automate the data analysis and making presentations

Cakemix is a Python library to open Office documents, automate the data analysis and making presentations

To install first time:
pip install cakemix

To upgrade:
pip install --upgrade cakemix


USAGE:

# importing cakemix.excel functions
from cakemix.excel import readExcel, get_column, plotBarData

# reading excel file. You can find this file in github: https://github.com/varlmes/python/blob/master/datatable_sample.xlsx
data=readExcel('C:\data\python\cakemix\datatable_sample.xlsx','Sheet1')

#showing the data
data

# getting the first column of data
result1=get_column(data,0)

# printing
result1[2:]

# getting the second column of data
result2=get_column(data,5)

# printing
result2[2:]

#plotting the data
plotBarData(result1[2:],(result2[2:]),'Salary','Name')


Example 2: from cakemix import list

from cakemix.list import *
out=findUniqueList([1,3,3,4,5,5,6])


Example 3: make sqlite database
	from db import makeDB
	makeDB('database.db')