Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: How to horizontally align and display images side-by-side in an email using Python?
Post: How to horizontally align and display images side-...
How can I horizontally align and display two images side-by-side using Python and HTML in an email? I've tried adding the images using HTML code, but they're currently being displayed vertically inste... |
|
shantanu97 |
General Coding Help |
0 |
997 |
Feb-22-2023, 11:41 PM |
|
|
Thread: Paginate API in python
Post: Paginate API in python
I am having trouble writing pagination code in Python
How does the API request work?
First call by the client will be the regular endpoint of the API. The response from the call contains pagination ... |
|
shantanu97 |
General Coding Help |
1 |
1,408 |
Sep-01-2022, 03:02 AM |
|
|
Thread: Problem in formulating append logic
Post: Problem in formulating append logic
I have a SQL Server table where 3 entries are present. I am passing these values one by one to an API function(Main) and getting Magnetic Declination(MD) value, then I need to append all the MD values... |
|
shantanu97 |
General Coding Help |
1 |
1,023 |
Jun-06-2022, 02:29 PM |
|
|
Thread: Convert nested sample json api data into csv in python
Post: Convert nested sample json api data into csv in py...
Want to convert Sample JSON data into CSV file using python. I am retrieving JSON data from API. As my JSON has nested objects, so it normally cannot be directly converted to CSV.I don't want to do an... |
|
shantanu97 |
General Coding Help |
3 |
2,806 |
May-20-2022, 10:47 PM |
|
|
Thread: Insert a multiple constant value after header in csv file using python
Post: Insert a multiple constant value after header in c...
Is it possible to insert 9 new lines of Constant Value("AA") in a CSV starting from the 2nd row? I need to insert the "AA" at the top 9 rows(after the header).
Original CSV look like this:
LEID,MI_RL... |
|
shantanu97 |
General Coding Help |
1 |
1,142 |
Apr-24-2022, 06:41 AM |
|
|
Thread: Want to shorten the python code
Post: Want to shorten the python code
My code works fine. However, I would like to shorten my code if there is a shorter way to write this. Does anyone have a solution? I have a lot of repeating things in my code. I just mentioned the sni... |
|
shantanu97 |
General Coding Help |
3 |
1,252 |
Apr-24-2022, 06:36 AM |
|
|
Thread: split txt file data on the first column value
Post: split txt file data on the first column value
I have a bunch of text files that look this.
H0002 Version 3
H0003 Date_gener... |
|
shantanu97 |
General Coding Help |
2 |
2,432 |
Dec-29-2021, 10:07 AM |
|
|
Thread: My python code is running very slow on millions of records
Post: RE: My python code is running very slow on million...
(Dec-28-2021, 02:23 AM)Larz60+ Wrote: untested, but close:
import pandas as pd
import glob
path = Your csv file path
os.path.join(path, "*.csv")
filelist = glob.glob(path + "/*.csv")
df = pd.conca... |
|
shantanu97 |
General Coding Help |
7 |
2,567 |
Dec-28-2021, 02:34 AM |
|
|
Thread: My python code is running very slow on millions of records
Post: RE: My python code is running very slow on million...
(Dec-27-2021, 11:18 PM)Larz60+ Wrote: I expect that you are paging memory.
How much memory do you have?
What paul18fr states about appending is true and should be avoided.
Do you need to have everyt... |
|
shantanu97 |
General Coding Help |
7 |
2,567 |
Dec-28-2021, 12:54 AM |
|
|
Thread: My python code is running very slow on millions of records
Post: RE: My python code is running very slow on million...
(Dec-27-2021, 12:22 PM)paul18fr Wrote: What type of data are you dealing with in the original csv file? pure numbers? strings? both? The
Appending is costly, and maybe loops can be avoided using v... |
|
shantanu97 |
General Coding Help |
7 |
2,567 |
Dec-28-2021, 12:50 AM |
|
|
Thread: My python code is running very slow on millions of records
Post: My python code is running very slow on millions of...
I want to process data through a python that has 2 million rows and more than 100 columns. My code takes 20 minutes to create an output file. I don't know if there is something else that make my code ... |
|
shantanu97 |
General Coding Help |
7 |
2,567 |
Dec-27-2021, 11:02 AM |
|
|
Thread: Compare filename with folder name and copy matching files into a particular folder
Post: Compare filename with folder name and copy matchin...
I am trying to write a python script that will use a regex to compare the file name that is present in the input folder with the output folder and if it matches, we, will copy that file from that inpu... |
|
shantanu97 |
General Coding Help |
2 |
4,471 |
Dec-18-2021, 11:22 AM |
|
|
Thread: Reshape txt file into particular format using python
Post: Reshape txt file into particular format using pyth...
1.I need to convert the following .txt file into csv format using Python. Basically, we need to reshape the wide txt data to long data format, but there doesn't seem to be a straightforward way to do ... |
|
shantanu97 |
General Coding Help |
0 |
1,423 |
Dec-10-2021, 11:44 AM |
|
|
Thread: How to transform from wide to long format in python
Post: How to transform from wide to long format in pytho...
Check the Problem-2.jpg file.
The files will (should) always be the same from columns A to H. The second last column will be S3Link. The columns between H and the S3Link column change between some fi... |
|
shantanu97 |
General Coding Help |
1 |
1,648 |
Nov-21-2021, 12:41 AM |
|
|
Thread: Not able to add extra column to the list in the python
Post: Not able to add extra column to the list in the py...
I have two excel files, and I wanted to append those files into one. But I also want to add a work book name of excel file into a column "SourceFile".
df = []
for fn in xlsx_files:
df.append(pd.r... |
|
shantanu97 |
General Coding Help |
2 |
1,647 |
Nov-17-2021, 06:45 AM |
|
|
Thread: Why doesn't drop_duplicates() modify my Dataframe?
Post: Why doesn't drop_duplicates() modify my Dataframe?
I have two files with exactly same data in it. My python reads that input file and fetch out all the necessary information and then save it in a CSV file. In short, python do data extraction from inpu... |
|
shantanu97 |
General Coding Help |
1 |
1,373 |
Oct-04-2021, 04:14 AM |
|
|
Thread: Problem in Regex Expression
Post: RE: Problem in Regex Expression
(Sep-28-2021, 03:36 AM)bowlofred Wrote: Is there something wrong? Your output seems to match your description.
I attach image how I wanted the output to look like. If you run the code, the output l... |
|
shantanu97 |
General Coding Help |
2 |
1,706 |
Sep-28-2021, 03:40 AM |
|
|
Thread: Problem in Regex Expression
Post: Problem in Regex Expression
I have file where I want to replace the particular row when a particular thing(string) matches with semicolon. If Equipment onsite is null/nothing then replace with semicolon, otherwise if there is an... |
|
shantanu97 |
General Coding Help |
2 |
1,706 |
Sep-28-2021, 03:29 AM |
|
|
Thread: Problem in saving .xlsm (excel) file using pandas dataframe in python
Post: Problem in saving .xlsm (excel) file using pandas ...
I have two macro excel files(.xlsm file) with different information. I have written the python code that basically checks certain fields, and if that certain field is present then it saves in one fold... |
|
shantanu97 |
General Coding Help |
2 |
4,267 |
Aug-29-2021, 09:41 AM |
|
|
Thread: How to combine multiple rows of strings into one using pandas?
Post: How to combine multiple rows of strings into one u...
I have a DataFrame with multiple rows. Is there any way in which they can be combined to form one rows? Marked with Yellow Colours. All I want to combine that into one row.
Remember that I wanted to ... |
|
shantanu97 |
General Coding Help |
1 |
3,138 |
Aug-18-2021, 12:47 PM |