1

I want to be able to create a cross table/table/dataframe (what ever the name) like this:

____________________      
Performance  "value" (This value must come from a X vector, which has a formula to go to dataset, calculate and return this value)
____________________
LTFU         "value" (This value must come from a y vector, which has a formula to go to dataset, calculate and return this value)
____________________

Please, note that Performance and LTFU values are generated from a function applied to a .csv dataset in python. Performance and LTFU don't exist in the .csv dataset, both should be created just to allow me do a summary of performance.

What I get now is as below:

import pandas as pd
performance=pd.read_csv("https://www.dropbox.com/s/08kuxi50d0xqnfc/demo.csv?dl=1")

x=performance["idade"].sum()
y=performance["idade"].mean()

l = "Performance"
k = "LTFU"

def test(y):
return pd.DataFrame({'a':y, 'b':x})

test([l,k])

         a        b
0   Performance   x vector value here (it shows 1300, it is correct)
1   LTFU          y vector value here (it shows 1300, it is wrong, it should show 14.130434782608695 instead, according to the instruction of y vector)

You can copy and paste the above code to your python IDE and test and then return with your solution to me. Please, show me an example with the table results as I want.

Improve this question
15
  • My text has beeen distorced here. I am posting a screenshsot Commented Feb 11, 2018 at 9:48
  • What are you trying to do? Are you trying to get the same format to save as CSV / txt? Or are you trying to summarize this dataframe to reuse? Commented Feb 11, 2018 at 11:50
  • @Deena, I am trying to summarize this dataframe with new variables. What I want is to calculate the those 2 values from another variables within dataset. I want to get new values generated by another calculation. Please, note that Perfomance and LTFU dont exist in the csv dataset.They are new variables just created to summarize want I want. Commented Feb 11, 2018 at 12:13
  • I am confused test([l,k]) return DataFrame. So need write it to file? Or need create another DataFrame from csv - Performance 1300 ____________________ LTFU 60, add it to test([l,k]) and write back? Commented Feb 12, 2018 at 9:39
  • Yeah, Jezrael. I need to create another table(or dataframe whatever the name) which contains Performance value that is correct 1300 according to my function above and also must contain LTFU value (which must not be 1300 because the function which generate this value is different from Performance). Did you get it? Commented Feb 12, 2018 at 9:44

2 Answers 2

Reset to default
0

You need assign output to DataFrame and then write to file by DataFrame.to_csv:

l = "Performance"
k = "LTFU"

#changed input to 2 scalar values
def test(l1,k1):
    #changed a to list [l1, k1]
    #changed b to list [x, y]
    return pd.DataFrame({'a':[l1, k1], 'b':[x, y]})

df1 = test(l,k)
print (df1)
             a            b
0  Performance  1300.000000
1         LTFU    14.130435
df1.to_csv('file.csv', index=False, header=None, sep=' ')
Improve this answer
Sign up to request clarification or add additional context in comments.

28 Comments

your code writes to a .csv and gives me the same wrong result as per vector y formula. I dont want to write to .csv the output. I just want that simple table as output only that but you need to correct to let y value be correct and not replicate x vector formula. Is there anyone who understands what I want, please, help me! I need that table output to be in DASH python Dashboard.
@MGB.py I have few question. 1. df1 = test([l,k]) print(df1) . This create dataframe, (table) generate from data from demo.csv. What need to do? Display only? Or something else? 2. Why are incorrect values in df1? If demo.csv contains only data from question, what is expected output? (I cannot see all data in file, so I try simplify it). 3. What is input to DASH python Dashboard? Dataframe? Dictionary? Something else? Please be patient, I try to help you. But your thinking and my is different, so it seems we dont understand each other. Thank you.
I am editing the question showing to you all demo dataset to let we talk same language. Wait.
@MGB.py Sure. I have main problem why df1 = test([l,k]) print(df1) is not your expected output. Because column 0, 1 and a, b first row? Or somwthing else?
so you had forgot what you did before. It happens!Ok. Thanks.
|
0

your requirement does not fit the definition of pandas data frame, you already have the values, so may be you can use output using other ways

Improve this answer

1 Comment

Looks like you did not understand my concern. Yesterday I have edited my question to be more clear to you. you already have the values, so may be you can use output using other ways - Which values? The second below value of 1300 on generated above table should not appear there, it is a replication of the above 1300 which is correct according to the function(formula) I have created.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.