Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: How to trigger python script twice a day
Post: How to trigger python script twice a day
Hi,
I want to trigger my python program every day at 8 am & 11 pm. I try to test this using below code, but the program did work well.
import schedule
import time
def job():
print("I'm worki... |
|
SriMekala |
General Coding Help |
1 |
3,902 |
Aug-29-2019, 03:17 PM |
|
|
Thread: How to drop column in pandas
Post: How to drop column in pandas
Hi,
I have below DataFrame,
Group Category Subject AC1 AC2 AC3 BM1 BM2 NJ1 NJ2 NJ3
Va Vb Vc Datecode Run1 Status Datecode Rank Datecode... |
|
SriMekala |
Data Science |
3 |
2,974 |
Aug-26-2019, 02:10 PM |
|
|
Thread: How to ignore formulas when reading excel file
Post: RE: How to ignore formulas when reading excel file
My input data is as below:
Caegory Model TM
Date WAT Actual Date Standard Cal
N22HN 2019-07-07 7 Fail 2019-08-01 Noraml 5/9
2019-07-22 12 1.36 2019... |
|
SriMekala |
General Coding Help |
3 |
6,504 |
Aug-16-2019, 03:52 PM |
|
|
Thread: How to ignore formulas when reading excel file
Post: How to ignore formulas when reading excel file
Hi,
I am reading an excel file which has formulas in a few columns names. When read using pd.read_ecel, the column names are becoming 0, 0.1, 0.2 etc. This may be because the cell contain formulas, ho... |
|
SriMekala |
General Coding Help |
3 |
6,504 |
Aug-16-2019, 03:14 PM |
|
|
Thread: How replace Unnamed header column with previous
Post: RE: How replace Unnamed header column with previou...
Category Group Group Sub_valid Sub_valid Sub_valid
Name Item Value Color Status
Group1 VGT Power 0 VGT Power
BHA Voltag... |
|
SriMekala |
Data Science |
3 |
5,150 |
Aug-15-2019, 12:13 AM |
|
|
Thread: How replace Unnamed header column with previous
Post: How replace Unnamed header column with previous
Hi,
I have excel file with merged columns as below:
Category Group Sub_valid
Name Item Value Color Status
Group1 VGT Power 0 VGT Power
BHA Voltage 1 BHA ... |
|
SriMekala |
Data Science |
3 |
5,150 |
Aug-14-2019, 03:43 PM |
|
|
Thread: How to modify df column
Post: How to modify df column
I have data in excel and want to modify one column:
Name Design Category Rank
DUT UIK Group2 5
HYT TYAHU Group1 1
PAT JKAL Group1 2
JKL PLK Group3 3I want... |
|
SriMekala |
Data Science |
1 |
2,479 |
Aug-14-2019, 02:43 PM |
|
|
Thread: deleted
Post: How to retain merged cells
Hi,
I read the excel sheet which has "merged cells", and I want to write another file retaining original merged cells. |
|
SriMekala |
Data Science |
1 |
78 |
Aug-10-2019, 07:19 AM |
|
|
Thread: Read exel with merged cells and write to another excel
Post: Read exel with merged cells and write to another e...
Hi,
I read the excel sheet which has "merged cells", and I want to write to another file retaining original merged cells.
My input excel is below:
Group Name Date Item Value
Group1 VGT 2016... |
|
SriMekala |
Data Science |
0 |
2,982 |
Aug-10-2019, 07:14 AM |
|
|
Thread: How to extract data between two strings
Post: RE: How to extract data between two strings
I want to replace resultsTable with
Group Name Rank
Group1 YJK_02 2
YMK_5 5
JKL 10
Group2 POL 4
PAL 5
TYP 50
D... |
|
SriMekala |
Data Science |
2 |
2,392 |
Aug-08-2019, 01:54 PM |
|
|
Thread: How to extract data between two strings
Post: How to extract data between two strings
Hi,
I have input data as below,
input.xlsx:
Group Name Rank
Group1 ABC_YJK_02_S_2019-08-01 2
ABC_YMK_5_S_2019-08-01 5
ABC_JKL_S_2019-08-04 10
Group2 BCA_POL_... |
|
SriMekala |
Data Science |
2 |
2,392 |
Aug-08-2019, 04:37 AM |
|
|
Thread: how read and write merged cells in excel
Post: how read and write merged cells in excel
Hi,
I have below data in which some of the cells are merged,
This data is saved in excel temp.xlsx, I want to read and write to another workbook detail.xlsx
Group Name Rank
Group1 ABC 2
... |
|
SriMekala |
Data Science |
1 |
15,130 |
Aug-07-2019, 02:17 PM |
|
|
Thread: How to get count of each unique item in dataframe
Post: RE: How to get count of each unique item in datafr...
pandas.__version__
Out[9]: '0.19.2'
python: 3.6.8.final.0 |
|
SriMekala |
Data Science |
7 |
3,775 |
Aug-06-2019, 02:32 PM |
|
|
Thread: How to get count of each unique item in dataframe
Post: RE: How to get count of each unique item in datafr...
it gives error:
TypeError: rename_axis() got an unexpected keyword argument 'columns' |
|
SriMekala |
Data Science |
7 |
3,775 |
Aug-06-2019, 12:39 PM |
|
|
Thread: How to get count of each unique item in dataframe
Post: RE: How to get count of each unique item in datafr...
I could do up to here, but I want to define the results as below:
Labels values
Fail 2
Pass 2 |
|
SriMekala |
Data Science |
7 |
3,775 |
Aug-04-2019, 09:05 AM |
|
|
Thread: How to get count of each unique item in dataframe
Post: How to get count of each unique item in dataframe
Hi,
I have below DataFrame:
data = {'Name':['Tom', 'nick', 'krish', 'jack'],
'Age':['Fail', 'Pass', 'Pass', 'Fail']}
I want to get the count of each unique item under column "Age"(for exampl... |
|
SriMekala |
Data Science |
7 |
3,775 |
Aug-03-2019, 06:01 PM |
|
|
Thread: How publish CSV to HTML
Post: RE: How publish CSV to HTML
I encounter one more issue,
import pandas as pd
df_hyper=pd.read_excel(r'D:\PythonCodes\hyperlink.xlsx',escape=False)
df_hyper.to_html('mylink.html',escape=False,index=False)Still, no hyperlinks reta... |
|
SriMekala |
Data Science |
5 |
3,063 |
Aug-03-2019, 05:44 AM |
|
|
Thread: How publish CSV to HTML
Post: RE: How publish CSV to HTML
I use as below, in my original data each cell have hyperlinks, but when use
df.to_html
the hyperlinks disappear. How to retain hyperlinks? |
|
SriMekala |
Data Science |
5 |
3,063 |
Aug-02-2019, 12:02 PM |
|
|
Thread: How publish CSV to HTML
Post: How publish CSV to HTML
Hi,
I use below code to come out a csv file with hyperlinks in each cell. I want to publish this as it is into HTML. Can someone please suggest if there is any fi=unction to do so.
import xlsxwriter
... |
|
SriMekala |
Data Science |
5 |
3,063 |
Aug-01-2019, 03:15 PM |
|
|
Thread: How to access dataframe elements
Post: RE: How to access dataframe elements
But some of the value is becoming "int", in fact, I need all the values to be "str". May be is it because of df.values? I use
temp=df.values[i, j].str()but it does not work. |
|
SriMekala |
Data Science |
4 |
3,231 |
Jul-26-2019, 08:37 AM |