|
Search Results
|
| Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
| |
|
Thread: Transposing a dataframe without creating NaN values
Post: Transposing a dataframe without creating NaN value...
| Hi! I have the data like this in a .csv file:
index data
1 10
2 20
3 30
4 40
5 50
6 10
2 20
3 30
4 40
5 ... |
|
doug2019 |
General Coding Help |
2 |
978 |
Mar-17-2023, 08:45 PM |
| |
|
Thread: Comparing two columns with same value but different font format
Post: Comparing two columns with same value but differen...
| Hi! I have a column of a dataframe with city names in capital letters and I wanted to compare it with the cities column of another dataframe with regular letters. It would be like a join. Join the ... |
|
doug2019 |
General Coding Help |
1 |
713 |
Jan-08-2023, 05:44 AM |
| |
|
Thread: "Vlookup" in pandas dataframe
Post: "Vlookup" in pandas dataframe
| Hi! How can I find a value in a column and return it from another column, like a vlookup? Below is an example dataframe.
import pandas as pd
]data = {"Name": ["John", "Michael", "Mary", "Jennifer"],... |
|
doug2019 |
General Coding Help |
3 |
1,853 |
May-08-2022, 11:42 PM |
| |
|
Thread: Reading .csv file
Post: RE: Reading .csv file
| Nothing worked. I tried with import csv, I put r before the path file, \\ as a separator, encoding: "utf-8" and sep: ";", but it didn't work. Could it be some VS Code configuration? |
|
doug2019 |
General Coding Help |
4 |
1,699 |
Apr-29-2022, 09:22 PM |
| |
|
Thread: Reading .csv file
Post: Reading .csv file
| Hi! Could someone give me a hand? I'm having trouble creating code to read a .csv file in pandas. With .xlsx file I know how to create it. Below is the print of the script and csv example.
[attac... |
|
doug2019 |
General Coding Help |
4 |
1,699 |
Apr-28-2022, 04:59 PM |
| |
|
Thread: Open only the Windows Explorer in Pandas
Post: RE: Open only the Windows Explorer in Pandas
| Great!!! The application I am building is for loading different .csv or .xlsx files so I would only need access to the folder where they will be. I just know how to write the code in Pandas to load o... |
|
doug2019 |
Data Science |
5 |
3,448 |
Jan-17-2021, 09:57 PM |
| |
|
Thread: Open only the Windows Explorer in Pandas
Post: Open only the Windows Explorer in Pandas
| I'm sorry. I think I didn't explain it properly. I want to write Python code that opens a window for me to choose the .csv or .xlsx files on directory just like the one in the attached image window. A... |
|
doug2019 |
Data Science |
5 |
3,448 |
Jan-17-2021, 08:30 PM |
| |
|
Thread: Open only the Windows Explorer in Pandas
Post: Open only the Windows Explorer in Pandas
| Hello! How can I open only the workbook to choose the .csv files I want to open with pandas? I know the method of the entire path to the file and not only to the workbook. |
|
doug2019 |
Data Science |
5 |
3,448 |
Jan-16-2021, 06:09 PM |
| |
|
Thread: Multiplying between two values
Post: RE: Multiplying between two values
| I am very grateful to everyone who helped me. All the answers are of great value for me to solve my problem with the code! |
|
doug2019 |
General Coding Help |
7 |
2,802 |
Oct-20-2020, 05:49 PM |
| |
|
Thread: Multiplying between two values
Post: RE: Multiplying between two values
| a=x
b=y
T=a.bDo x . y but T < 10 and show one list for x values and other list for y values. Both x and y can have one decimal place. I'm sorry for my explanation. |
|
doug2019 |
General Coding Help |
7 |
2,802 |
Oct-19-2020, 11:17 PM |
| |
|
Thread: Multiplying between two values
Post: Multiplying between two values
| I need an equation in Python that gives me the values that can be multiplied, since they must be less than 10. Only they must have one decimal place before, like 0.1. That's what I'm having a proble... |
|
doug2019 |
General Coding Help |
7 |
2,802 |
Oct-19-2020, 10:14 PM |
| |
|
Thread: Press a botton to continue the code
Post: Press a botton to continue the code
| Hi! Is there any command or function in Python to run the code in steps, ie set breakpoints that continue to press a button or mouse click? I need to create something like this in my code! |
|
doug2019 |
General Coding Help |
1 |
1,850 |
Nov-18-2019, 09:27 AM |
| |
|
Thread: Yes or No code
Post: RE: Yes or No code
| def return ()
#.
#.
#.
while (a>b):
print("This value is wrong.")
question=input("Do you want to return to the start? Enter Y for Yes or N for No")
... |
|
doug2019 |
General Coding Help |
8 |
3,095 |
Nov-15-2019, 05:52 AM |
| |
|
Thread: Yes or No code
Post: RE: Yes or No code
| Now I get it! First I need to create a variable and then test it with the if conditional. Thank you so much! |
|
doug2019 |
General Coding Help |
8 |
3,095 |
Nov-14-2019, 02:29 PM |
| |
|
Thread: Yes or No code
Post: RE: Yes or No code
| Y=True
print("Do you want to return to the start?")
if Y:
#This code I already have.
else:
#This code I do not know how to do. |
|
doug2019 |
General Coding Help |
8 |
3,095 |
Nov-14-2019, 01:53 PM |
| |
|
Thread: Yes or No code
Post: Yes or No code
| I know this is simple code, but I am in doubt. I need code that interacts with the user, asking if he wants to continue the algorithm or not. If "Yes (Y)" returns to the beginning, if "No (N)" ends ... |
|
doug2019 |
General Coding Help |
8 |
3,095 |
Nov-14-2019, 01:30 PM |
| |
|
Thread: Def code does not work for negative integers.
Post: Def code does not work for negative integers.
| The def code when it results in negative does not work. I don't know how to solve it.
def conversao(x):
if x < GPa:
return(str(int(x/MPa))+"MPa")
elif x >= GPa:
return(st... |
|
doug2019 |
General Coding Help |
1 |
1,905 |
Oct-31-2019, 10:56 PM |
| |
|
Thread: Define unit of measure of a number
Post: Define unit of measure of a number
| I would like a function or command to define the unit of measure, either MPa (10 ^ 6) or GPa (10 ^ 9).e.g
20,000,000,000.00 > 20GPa
5,000,000.00 > 5MPa |
|
doug2019 |
General Coding Help |
3 |
2,374 |
Oct-15-2019, 02:57 AM |
| |
|
Thread: Question about list and while function
Post: RE: Question about list and while function
|
doug2019 |
General Coding Help |
6 |
2,735 |
Oct-12-2019, 03:07 AM |
| |
|
Thread: Question about list and while function
Post: RE: Question about list and while function
| I understand but the problem is that list must always have 10 elements and "a" and "b" will be input by the user. |
|
doug2019 |
General Coding Help |
6 |
2,735 |
Oct-11-2019, 03:54 AM |
