Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: openpyxl insert picture problem
Post: RE: openpyxl insert picture problem
(May-02-2023, 08:09 AM)buran Wrote: (May-02-2023, 01:43 AM)cools0607 Wrote: failed to get the proper image size from the cell border.What exactly does it mean to get image size from cell border? ...
 cools0607 General Coding Help 2 1,572 May-03-2023, 06:48 AM
    Thread: openpyxl insert picture problem
Post: openpyxl insert picture problem
I want to insert a picture into the Excel cell. The image size needs to fit the cell (even the merged cell) border automatically. I can find an example to insert a picture in Excel. But I failed to ...
 cools0607 General Coding Help 2 1,572 May-02-2023, 01:43 AM
    Thread: Pandas's regular expression function result is so strange
Post: RE: Pandas's regular expression function result is...
sorry for another question. I tried to search lots of data from Excel. After importing data to list(data structure). I tried two methods. 1. using list with re module search. 2. Transfer list --> ...
 cools0607 General Coding Help 6 3,198 Jun-15-2020, 07:34 AM
    Thread: Pandas's regular expression function result is so strange
Post: RE: Pandas's regular expression function result is...
Thank you for your reply. After trying your code, I got it. I think it is convenient for me to use .str.contains(r'^AA'). (Jun-12-2020, 10:14 AM)snippsat Wrote: (Jun-12-2020, 09:35 AM)cools0607 Wr...
 cools0607 General Coding Help 6 3,198 Jun-15-2020, 03:16 AM
    Thread: Pandas's regular expression function result is so strange
Post: RE: Pandas's regular expression function result is...
Sorry for another question. I wonder if .str.contains includes specified functions just like re module? For example: '^AA' expresses only searching words start with AA. (Jun-05-2020, 11:56 AM)snipps...
 cools0607 General Coding Help 6 3,198 Jun-12-2020, 09:35 AM
    Thread: check pandas variable type
Post: RE: check pandas variable type
Oh! I just got a lesson by isinstance this function. Thank for your assistance. (Jun-12-2020, 08:47 AM)buran Wrote: you compare type of the object with str object - that's why it's false. As per th...
 cools0607 General Coding Help 3 6,705 Jun-12-2020, 09:21 AM
    Thread: check pandas variable type
Post: check pandas variable type
I am trying to check variable's data type is list or dataframe. When I got type(df_c) is Out[155]: pandas.core.frame.DataFrame. Checking it again by type(df_c) == 'pandas.core.frame.DataFrame', it s...
 cools0607 General Coding Help 3 6,705 Jun-12-2020, 07:47 AM
    Thread: miscalculation on "100*e-6"
Post: RE: miscalculation on "100*e-6"
I appreciate your reply to my problem. Your code and background are very useful for me. Although I am still puzzled with "format(100*1e-6, ".15e") -->9.999999999999999e-05"... (Jun-11-2020, 08:...
 cools0607 General Coding Help 4 2,434 Jun-12-2020, 07:32 AM
    Thread: miscalculation on "100*e-6"
Post: miscalculation on "100*e-6"
I am trying to make a calculation: 100*e-6, but got wrong answer: 9.999999999999999e-05. I also tried: 100*0.000001 All of them are not reasonable. 100*1e-6 Out[103]: 9.999999999999999e-05 100*0.0000...
 cools0607 General Coding Help 4 2,434 Jun-11-2020, 07:54 AM
    Thread: Pandas's regular expression function result is so strange
Post: RE: Pandas's regular expression function result is...
Thank you for your quick reply. It's workable, achieved my goal. (Jun-05-2020, 11:56 AM)snippsat Wrote: Can use str.contains for this. import pandas as pd k = [ ["a", "b", "c", "NOPOP"], ...
 cools0607 General Coding Help 6 3,198 Jun-11-2020, 07:46 AM
    Thread: Pandas's regular expression function result is so strange
Post: Pandas's regular expression function result is so ...
I am trying to make a regular express for df1(dataframe). I want to remove the expression related NOPOP.NoPop and NONPOP information in 3rd column. In order to achieve quick search, I put 3rd column a...
 cools0607 General Coding Help 6 3,198 Jun-05-2020, 09:20 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020