Skip to main content

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

cakemix-0.0.12.tar.gz (9.5 kB view details)

Uploaded Source

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

Hashes for cakemix-0.0.12.tar.gz
Algorithm Hash digest
SHA256 39b40522512a2de54b25da5f75c1f0b7c5177fe66722d26bec0f81e30e16ad79
MD5 61e2bac96ae49b40331e44f17eb7f174
BLAKE2b-256 de1e3ef775dfa4bb906ae79680921e514217b9e8c369b9b700596fc35a51d5ee

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page