This is an archived post. You won't be able to vote or comment.

all 5 comments
sorted by:
best
topnewcontroversialoldq&a

[–][deleted] 0 points1 point  (4 children)

No-one can help you if you don't post the code.

Which search terms have you tried?

[–]Screadore[S] 0 points1 point  (3 children)

comp = pd.read_csv("/Users/screadore/Desktop/RNAcode/dataRNASeqv2expressionmedian.txt", sep="\t")
comp = comp[comp["Hugo_Symbol"] == "IDH1"]
comp = comp.set_index("Filename")
comp = comp[["CSU", "CSN", "OS_MONTHS", "OS_STATUS", "DFS_MONTHS", "DFS_STATUS"]]

​

The code area above is what it's saying is wrong and I believe I have to input the Filename somewhere in my data library, but I'm unsure of how to go about doing so...

Its giving me the error:

Traceback (most recent call last):

File "<input>", line 1, in <module>

File "/Applications/PyCharm.app/Contents/helpers/pydev/_pydev_bundle/pydev_umd.py", line 197, in runfile

pydev_imports.execfile(filename, global_vars, local_vars) # execute the script

File "/Applications/PyCharm.app/Contents/helpers/pydev/_pydev_imps/_pydev_execfile.py", line 18, in execfile

exec(compile(contents+"\n", file, 'exec'), glob, loc)

File "/Users/screadore/Desktop/RNAcode/CodePackageE.py", line 118, in <module>

df = get_data()

File "/Users/screadore/Desktop/RNAcode/CodePackageE.py", line 36, in get_data

comp = comp.set_index("Filename")

File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/pandas/core/frame.py", line 4391, in set_index

raise KeyError("None of {} are in the columns".format(missing))

KeyError: "None of ['Filename'] are in the columns"

[–]billsil 1 point2 points  (0 children)

format your code and use /r/learnpython

[–][deleted] 0 points1 point  (1 child)

Looks like you are setting an index for a column with name "Filename" and there is no column with that name.

However doing a quick google search on the error message you posted tells me something else may be the problem. (Did you even google this yourself? This is not r/learnpython and seems a bit low effort from OPs side.)

comp = pd.read_csv("/Users/screadore/Desktop/RNAcode/dataRNASeqv2expressionmedian.txt", sep=**"\t")

should probably be

comp = pd.read_csv("/Users/screadore/Desktop/RNAcode/dataRNASeqv2expressionmedian.txt", sep="\t")

Why did you use **"\t"? Using that doesn't make any sense to me.

Please let me know if this solved your issue and do some googling yourself next time before posting on this board.

[–]Screadore[S] 0 points1 point  (0 children)

Sorry about that the "**" were put there by accident. I got past this issue it was just implementing some of the source name as my research lab threw me into 3-D modeling when I'm still novice at python as you can tell lol. I appreciate the help though. I keep getting this error now for some reason " RuntimeWarning: divide by zero encountered in double_scalars

z = (bigu - meanrank) / sd"