Skip to content

Instantly share code, notes, and snippets.

View jerilkuriakose's full-sized avatar

Jeril Kuriakose jerilkuriakose

  • Cochin, Kerala, India
View GitHub Profile
#!/bin/bash
dbus-send --system --print-reply --dest=org.freedesktop.login1 /org/freedesktop/login1 "org.freedesktop.login1.Manager.Suspend" boolean:true
1
2
5
1
2
9
8
4
6
7
1
2
5
1
7
9
8
4
6
7
a = 25
from pandas import DataFrame
# import the required library to open HDF file
from pandas import HDFStore
# File that stores the dataframe
filename = 'data.h5'
# Creating a dataframe
df = DataFrame(np.random.randn(5,3), columns=['A', 'B', 'C',])
class OpenHDFS():
# Using our context manager
with OpenHDFS(filename) as store:
store.put('d1', df)
# import the required library to open HDF file
from pandas import HDFStore
class OpenHDFS():
"""
Context Manager class to open / create a HDFS / h5 file
"""
def __init__(self, filename):
"""
import scipy
import matplotlib.pyplot as plt
import scipy.cluster.hierarchy as sch
# %matplotlib inline
# uncomment the above line if using Jupyter notebook
# creating dummy variable for plotting
# 'D' is a 2-d array that has our data
# for demonstartion purpose we are creating random variables
x = scipy.rand(40)
# Used to clean and analyse the data-set
import pandas as pd
# To open an excel file
df = pd.ExcelFile('myexcel.xls').parse('Sheet1')
@jerilkuriakose
jerilkuriakose / convert_excel.py
Last active May 20, 2024 07:19
Recover corrupt excel file using Python
# Changing the data types of all strings in the module at once
from __future__ import unicode_literals
# Used to save the file as excel workbook
# Need to install this library
from xlwt import Workbook
# Used to open to corrupt excel file
import io
filename = r'SALEJAN17.xls'
# Opening the file using 'utf-16' encoding