Python library to open Office documents, automate the data analysis and making presentations
Project description
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')
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
File details
Details for the file cakemix-0.0.12.tar.gz
.
File metadata
- Download URL: cakemix-0.0.12.tar.gz
- Upload date:
- Size: 9.5 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.4.1 importlib_metadata/4.4.0 pkginfo/1.7.0 requests/2.22.0 requests-toolbelt/0.9.1 tqdm/4.61.0 CPython/3.8.10
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | 39b40522512a2de54b25da5f75c1f0b7c5177fe66722d26bec0f81e30e16ad79 |
|
MD5 | 61e2bac96ae49b40331e44f17eb7f174 |
|
BLAKE2b-256 | de1e3ef775dfa4bb906ae79680921e514217b9e8c369b9b700596fc35a51d5ee |