Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: Nan values after merging 2 dataframes
Post: Nan values after merging 2 dataframes
Hello, I have two pandas dataframes that merged correctly using the "left on = " ", right on =" " method, but after the merge, some of my values in one column are getting Nan in it's row. I've confirm... |
|
EmBeck87 |
General Coding Help |
1 |
1,025 |
Apr-19-2023, 02:01 PM |
|
|
Thread: doing data treatment on a file import-parsing a variable
Post: data
data.......................... |
|
EmBeck87 |
General Coding Help |
15 |
2,914 |
Apr-17-2023, 06:54 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
I can't wrap my head around this BBCode stuff right now. These are the actual columns and some of the data. I'll put the full coding below it.
SUBJID SAMPLEID BENCH WHO MIC1 BMD1 PO... |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 05:08 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
This is not my code, and it does work so I think it is applicable. |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 04:43 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
I will send you the actual file. That was just a mockup. I do need the coding mentioned accomplished, not just the values generated, but the objectives accomplished: MIC_FLOAT with floating format for... |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 04:07 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
To take out spaces I think. |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 02:26 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
(Apr-13-2023, 02:07 PM)EmBeck87 Wrote: This is from another project that I'm using for a base the numbers are very similar.
ID MIC1 MIC_FLOAT MIC_FOR_RANGES
1 = 0.... |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 02:10 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
This is from another project that I'm using for a base the numbers are very similar.
ID MIC1 MIC_FLOAT MIC_FOR_RANGES
1 = 0.0625 0.0625 0.0625
2 ... |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 02:07 PM |
|
|
Thread: Problems with converting to numeric
Post: RE: Problems with converting to numeric
Let me clarify. I think what I need to do is replace Nan values in a column with the actual floating point values in the dataframe. How can I convert Nan values to show the actual values? |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-13-2023, 12:33 PM |
|
|
Thread: Problems with converting to numeric
Post: Problems with converting to numeric
This code for converting the values to numeric is also removing characters, I believe.
Can someone advise on how to alter it so it keeps the characters, except for the first line of code that remove... |
|
EmBeck87 |
Homework |
13 |
2,189 |
Apr-12-2023, 05:14 PM |
|
|
Thread: Interpreting this code
Post: RE: Interpreting this code
|
EmBeck87 |
Homework |
4 |
1,547 |
Apr-10-2023, 12:40 PM |
|
|
Thread: Interpreting this code
Post: RE: Interpreting this code
Does this exclude LMU? All I really need to know, thanks. |
|
EmBeck87 |
Homework |
4 |
1,547 |
Apr-07-2023, 07:48 PM |
|
|
Thread: Interpreting this code
Post: Interpreting this code
Hello, I have a dumb question- can someone tell me in layperson terms what this code is doing? I'm worried it is excluding the values I want 'LMU' instead of including them. Thank you.
#Remove all th... |
|
EmBeck87 |
Homework |
4 |
1,547 |
Apr-07-2023, 04:36 PM |
|
|
Thread: Using log to calculate difference
Post: Using log to calculate difference
Hello, I have some code for diluting the difference between results using numpy.log. It goes like:
df[new value]=(np.log(df[values1]-nplog(df[values2])/np.log(2),df[values1]-df['values3])
The above... |
|
EmBeck87 |
General Coding Help |
1 |
730 |
Apr-04-2023, 07:56 PM |
|
|
Thread: Code for pullng all data in a column
Post: RE: Code for pullng all data in a column
Hm, yeah, that didn't really work either. It counted out a list of numbers in an array up to 9,999, it didn't print the values in the column. |
|
EmBeck87 |
General Coding Help |
5 |
1,120 |
Apr-03-2023, 03:17 PM |
|
|
Thread: Code for pullng all data in a column
Post: RE: Code for pullng all data in a column
Thanks, it does not show me all the values from the dataframe column though, it shows me a few values at the beginning and a few values at the end, with ... in the middle. How can I see all the values... |
|
EmBeck87 |
General Coding Help |
5 |
1,120 |
Apr-03-2023, 02:28 PM |
|
|
Thread: Code for pullng all data in a column
Post: Code for pullng all data in a column
Hi all, could someone suggest some code for pulling all the data from one column in a dataframe that was pulled in? I have tried a couple different combinations, but they haven't been working. All oth... |
|
EmBeck87 |
General Coding Help |
5 |
1,120 |
Mar-31-2023, 09:19 PM |
|
|
Thread: doing data treatment on a file import-parsing a variable
Post: RE: doing data treatment on a file import-parsing ...
Is there a way to do this so that two new columns are not made, just the one column, VIS_ISOLATE_NUMBERS? |
|
EmBeck87 |
General Coding Help |
15 |
2,914 |
Mar-30-2023, 05:25 PM |
|
|
Thread: doing data treatment on a file import-parsing a variable
Post: RE: doing data treatment on a file import-parsing ...
Let me clarify- this code has worked perfectly before adding the code for parsing. Files have been imported already earlier in the code and specified, that all works just fine. I do not need to repeat... |
|
EmBeck87 |
General Coding Help |
15 |
2,914 |
Mar-30-2023, 04:50 PM |
|
|
Thread: doing data treatment on a file import-parsing a variable
Post: RE: doing data treatment on a file import-parsing ...
Hi Dean, I inserted the code into my existing code for reading the file and deleting empty lines. I altered it some because the file is an excel file, and am getting the following error:
TypeError: r... |
|
EmBeck87 |
General Coding Help |
15 |
2,914 |
Mar-30-2023, 03:07 PM |