Posts

Showing posts from 2019

Filter excel based on color of cell

import numpy as np import pandas as pd from StyleFrame import StyleFrame, utils sf = StyleFrame.read_excel('.\\el_data\\sample_name.xlsx', read_style=True, use_openpyxl_styles=False) def only_cells_with_red_text(cell):     return cell if cell.style.font_color in {utils.colors.red, 'FFFF0000'} else np.nan sf_1 = sf[['OLD_DOB']] sf_2 = StyleFrame(sf_1.applymap(only_cells_with_red_text).dropna(axis=(0, 1), how='all')) df=pd.DataFrame(sf.data_df) df_2=df.iloc[sf_2.index] print(df_2)

Do Shabd

काफी खामोश सा है ये गलियारा, कुछ चेहरे चुपके से झाँकते है बैठे है नज़रो को टिकाये हम भी, कभी इधर  तो कभी उधर ताकते है

ToDo list 3

CHANGE AND IMPACT MANAGEMENT UP Pendency Stats Dashboard - Improve employer level *Form 5A pendency   View code access from C-DAC and changes pushed by them Change log page remove/hide international status from the profile page Software to help in ECR challans making Ask for 26(6) permission for establishment contributing at more than ceiling while filling challan Facility to add extra information in Online Claim either date of leaving/date of joining (earlier service) - checkbox for earlier service  Online claim/field office claim all should be entered by DA receipt through Unified portal (DA recept role at field office application may be disabled)  Dummy logins Online 15G/H upload  C-DAC code version control Reports-  DSC expired, pending, approved, going to expire Dashboard for online and offline claims merged together  Monitoring of who requests what at what rate should be automatically generated at ACC, RC level. Giving or Requesting report should be ban

To do list updated 2

CHANGE AND IMPACT MANAGEMENT 1.        UP - Pendency Stats Dashboard - Improve employer level 2.        UP - Pendency Stats Dashboard - Make office level 3.        UP - Form 5A pendency 4.        UP - Delinking of Aadhaar from incorrect UAN 5.        UP - View code access from C-DAC and changes pushed by them 6.        UP - Change log page 7.        UP -   Automating of Name change request categorization 8.        UP - Software to help in ECR challans making 9.        UP - Ask for 26(6) permission for establishment contributing at more than ceiling while filling challan 10.    UP - Facility to add extra information in Online Claim either date of leaving/date of joining (earlier service) - checkbox for earlier service 11.    UP - Online claim/field office claim all should be entered by DA receipt through Unified portal (DA recept role at field office application may be disabled) 12.    UP - Dummy logins 2.1 UP - remove/hide international status

China Timeline

1517 - The Portuguese arrive and establish trade with China. Qing Dynasty (1644 to 1912) 1900 - The Boxer Rebellion occurs with violence against foreigners and Christians. International forces intervene. 1908 - Puyi becomes the last Emperor of China at the age of 2. 1910 - Slavery is abolished in China. 1911 - The Qing dynasty is overthrown by the Xinhai Revolution. Republican Era (1912 to 1949) 1912 - Revolutionary Sun Yat-sen becomes the first President of the Republic of China. 1912 - China adopts the Gregorian Calendar. 1917 - China joins World War I and declares war on Germany. 1927 - The Ten Years Civil War occurs between the Kuomintang nationalists, led by Chiang Kai-shek , and the communist party, led by Mao Zedong . 1928 - Chiang Kai-shek becomes the Chairman of the National Government of China. 1934 - Mao Zedong leads his people on a retreat across China called the Long March. 1937 - China is invaded by Japan. Japan captures several important cities including Be

Russia timeline

1609 - The start of the Polish-Russian War. Poland invades Russia. 1613 - The Romanov dynasty begins when Michael Romanov is elected Tsar. The Romanov dynasty will rule until 1917. 1648 - The Salt Riot occurs in Moscow over the introduction of a salt tax. 1654 - Russia invades Poland. 1667 - Russia and Poland sign a peace treaty. 1689 - Peter the Great becomes tsar. He will establish Russia as a world power introducing reforms and creating a standing army. 1700 - The start of the Great Northern War with Sweden.1721 - Russia wins the Great Northern War gaining territory including Estonia and Livonia. 1736 - Start of the Russo-Turkish War against the Ottoman Empire. 1757 - Russian troops join in the Seven Years' War. 1762 - Russia leaves the Seven Years' War with no territory gained. 1762 - Tsar Peter III is assassinated and his wife Catherine II takes the crown. She will rule for 34 years in what will be called the Golden Age of the Russian Empire. Nepoleon 1812 - Napol

Datatypes supported by Numpy

Data type Description bool_ Boolean (True or False) stored as a byte int_ Default integer type (same as C long; normally either int64 or int32) intc Identical to C int (normally int32 or int64) intp Integer used for indexing (same as C size_t; normally either int32 or int64) int8 Byte (–128 to 127) int16 Integer (–32768 to 32767) int32 Integer (–2147483648 to 2147483647) int64 Integer (–9223372036854775808 to 9223372036854775807) uint8 Unsigned integer (0 to 255) uint16 Unsigned integer (0 to 65535) uint32 Unsigned integer (0 to 4294967295) uint64 Unsigned integer (0 to 18446744073709551615) float_ Shorthand for float64 float16 Half precision float: sign bit, 5-bit exponent, 10-bit mantissa float32 Single precision float: sign bit, 8-bit exponent, 23-bit mantissa float64 Double precision float: sign bit, 11-bit exponent, 52-bit mantissa complex_ Shorthand for complex128 complex64 Complex number, represented by two 32-bit floats (real and imaginary components) complex128 Complex number

ToDo List Updated

CHANGE AND IMPACT MANAGEMENT 1.        UP - Pendency Stats Dashboard - Improve employer level 2.        UP - Pendency Stats Dashboard - Make office level 3.        UP - Form 5A pendency 4.        UP - Delinking of Aadhaar from incorrect UAN 5.        UP - View code access from C-DAC and changes pushed by them 6.        UP - Change log page 7.        UP -   Automating of Name change request categorization 8.        UP - Software to help in ECR challans making 9.        UP - Ask for 26(6) permission for establishment contributing at more than ceiling while filling challan 10.    UP - Facility to add extra information in Online Claim either date of leaving/date of joining (earlier service) - checkbox for earlier service 11.    UP - Online claim/field office claim all should be entered by DA receipt through Unified portal (DA recept role at field office application may be disabled) 12.    UP - Dummy logins 13.    Reports - DSC expired, pending,