How to store the printed values

Question

1.00/5 (1 vote)

See more:

I have written a for loop for the dataframe. I need to store the printed output into a variable to be used. how to store the printed variable. The variable which contains the "Non-Sachet" and "Sachet" Printed Values must be added to the dataframe as columns. As such if i know how to store the printed "Non-Sachet" and "Sachet" Values as list i can easily add the values in the variable as columns in dataframe

What I have tried:

Python

import pandas as pd
import numpy as np
df=pd.read_excel(r'D:\Practice Files\Anirudh Exercise Skin India.xlsx')
#Sachet/Non-Sachet
Sachet=df["Basepacksize"].tolist()
first_element=10
for int in Sachet:
   if first_element !=int:
    print("Non-Sachet")
   else:
      print("Sachet")

Posted 12-Dec-22 5:45am

Anirudh Sudarsan

Updated 12-Dec-22 7:11am

v2

Add a Solution

Comments

Richard MacCutchan 12-Dec-22 12:01pm

As with your other questions, the problem is with your data. But unless you show it to us we cannot guess what is wrong with it. And the above code does not make a lot of sense.

Anirudh Sudarsan 12-Dec-22 12:21pm

sry bro its company client data. NDA and all that sh*t and yes its the client who provide the data in excel.
The Main Purpose is to store all the Sachet and Non-Sachet Outputs and add it into the dataframe for analysis purpose. Thats why i asked how to store all the "Non-Sachet" and "Sachet" Printed Output in a variable so that it can be added to dataframe as a column.
Also i am a fresher currently on training. So any help is appreciated

Richard MacCutchan 12-Dec-22 12:32pm

What do "Non-Sachet" and "Sachet" mean, they are not terms that I am familiar with? Also if you are on training then you should speak to your senior(s) about what is necessary. I assume someone within your company knows what this task is about.

Anirudh Sudarsan 12-Dec-22 12:38pm

sachet means small things like 18 Cents Shampoo Packet. Also i would like to consult the net before going to them as a final resort. also is it possible to use things like closure() for storing the printed values. if so how to do it

Richard MacCutchan 12-Dec-22 12:43pm

Well if you cannot show us the data you are working with, and explain exactly what you are trying to achieve then it is difficult for us to offer suggestions.

Anirudh Sudarsan 12-Dec-22 12:47pm

Column which is used "Base Pack Size" Refers to the Size of any item. if the Size is less than 10 it is classified as a Sachet. I need to add the printed value as a Column which Specifies which Items are Sachets and which are not. The Client needs to see how many and which sachets sold the highest. you know data analytics stuff like that.

Richard MacCutchan 12-Dec-22 16:34pm

Go to The Python Tutorial — Python 3.10.9 documentation[^] and spend some time learning Python properly.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2022-12-12T06:11:00

You need to sit down and work out exactly what you are doing, or trying to do: that code doesn't do anything particularly useful, and appears to have been "thrown together" with little or no planning.

Work out what you want to achieve, and start planning from there: what do you want to "store", how long do you want to store it, what are you going to do with it later? These are important, as a "store it so I can use it next time the app runs" solution is very different from a "store it so I can use it after the loop" would be.

And please, don't use Excel to store data: That's not a database, dude![^]

Dave Kreskowiak · Answer 2 · 2022-12-12T07:11:00

Solution 2

Why is Googling for this so hard to do?

how to store data in Excel using pandas - Google Search[^]

Posted 12-Dec-22 7:11am

Dave Kreskowiak

Comments

Anirudh Sudarsan 12-Dec-22 13:14pm

Not Exactly I need to store the "Sachet" and "Non-Sachet" Printed Values in a python variable on analysis purpose. not storing a column on excel using pandas

Dave Kreskowiak 12-Dec-22 13:16pm

OK, even worse. You're telling me you don't know how to store values in an array.

Python how to store values in an array - Google Search[^]

Anirudh Sudarsan 12-Dec-22 13:18pm

did you fully read the question. i told that i need to store the "non-sachet" and "sachet" values printed by print command using if condition and for loop

Dave Kreskowiak 12-Dec-22 13:31pm

Yeah, AND? I did read your entire question, which, frankly, doesn't make a whole lot of sense.

You can both print something on screen and store a string in an array. You seem to be fixed on redirecting print output to a variable and that's not really the way you should be doing that.

Anirudh Sudarsan 13-Dec-22 1:39am

understood and i created a list and appended the output value to it. so consider this problem solved