Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: How do I translate this into python code? (excel vlookup)
Post: RE: How do I translate this into python code? (exc...
hello, just wondering if someone can please help me with this. thank you
 eeps24 Data Science 6 2,816 May-29-2020, 05:54 PM
    Thread: How do I translate this into python code? (excel vlookup)
Post: RE: How do I translate this into python code? (exc...
I figured how to use the merge command (sorta). The following code combines both df1 and df2 together- (I added left/right on because this is the column I need to merge on). Works great but I dont wan...
 eeps24 Data Science 6 2,816 May-27-2020, 08:52 PM
    Thread: How do I translate this into python code? (excel vlookup)
Post: RE: How do I translate this into python code? (exc...
(May-26-2020, 03:19 PM)buran Wrote: pandas.DataFrame.merge() thank you! I will begin coding.
 eeps24 Data Science 6 2,816 May-26-2020, 03:38 PM
    Thread: How do I translate this into python code? (excel vlookup)
Post: RE: How do I translate this into python code? (exc...
Hi Larz, Thank you for responding. I 100% agree an effort should be made. The only problem is I dont know which function to use to get started. (something that works with two dataframes) I dont ne...
 eeps24 Data Science 6 2,816 May-26-2020, 12:40 PM
    Thread: How do I translate this into python code? (excel vlookup)
Post: How do I translate this into python code? (excel v...
I have two dataframes and trying to do a excel vlookup type function. excel's vlookup parameters: vlookup(lookup_value,table_array,col_index_num,range_lookup How would I translate the following into ...
 eeps24 Data Science 6 2,816 May-26-2020, 01:39 AM
    Thread: trying to do a vlookup in pandas
Post: RE: trying to do a vlookup in pandas
curious if anyone knows? thank you
 eeps24 General Coding Help 1 1,957 May-22-2020, 02:10 PM
    Thread: trying to do a vlookup in pandas
Post: trying to do a vlookup in pandas
Trying to do a "vlookup" with pandas. I have two data frames loaded. I suppose I would need to do a merge to connect both data frames. But my question is, how do I tell it which column to bring in for...
 eeps24 General Coding Help 1 1,957 May-21-2020, 03:31 PM
    Thread: How to keep leading zeros with pandas?
Post: How to keep leading zeros with pandas?
I have a csv file with 4 columns. col 1 (numbers) col 2 (text) col 3 (numbers) col 4 (text) technically all four columns have a format type of general, basically my number are not really numbers whic...
 eeps24 General Coding Help 1 6,565 May-20-2020, 04:06 PM
    Thread: Pandas: .(head) Can I specify a range in head?
Post: RE: Pandas: .(head) Can I specify a range in head?
sorry please ignore my previous post.. I saw your code above. (May-11-2020, 04:26 PM)buran Wrote: (May-11-2020, 04:08 PM)buran Wrote: Probably sf.toPandas().iloc[10:21] it worked thank you!!!
 eeps24 General Coding Help 6 3,725 May-11-2020, 04:27 PM
    Thread: Pandas: .(head) Can I specify a range in head?
Post: RE: Pandas: .(head) Can I specify a range in head?
sorry about that. SF is the name of my data frame...its coming from pyspark and then I am moving the data in to pandas. sf.toPandas().head(20) Do you know who I would modify this line? Currently it...
 eeps24 General Coding Help 6 3,725 May-11-2020, 04:11 PM
    Thread: Pandas: .(head) Can I specify a range in head?
Post: RE: Pandas: .(head) Can I specify a range in head?
this is what i have now... sf.toPandas().head(20) can you please help format what I should have? Thank you
 eeps24 General Coding Help 6 3,725 May-11-2020, 03:54 PM
    Thread: Pandas: .(head) Can I specify a range in head?
Post: Pandas: .(head) Can I specify a range in head?
In pandas, is it possible to specify a range in head? for example say I want to view rows 10-20, is there something where I can do... .head(10-20)
eeps24 General Coding Help 6 3,725 May-11-2020, 03:19 PM
    Thread: few questions (I am a beginner)
Post: RE: few questions (I am a beginner)
(Sep-27-2019, 01:39 PM)eeps24 Wrote: 2. Can python be used to query a SQL database? How about a NoSQL database? yes on both counts. Popular database providers have python bindings/connectors already...
 eeps24 News and Discussions 3 2,356 Sep-27-2019, 02:16 PM
    Thread: few questions (I am a beginner)
Post: few questions (I am a beginner)
**huh** I am very new to python and having a hard time understanding some basic things. Can anyone please help me with the following? Can you please answer my questions in the same format? Thank you ...
 eeps24 News and Discussions 3 2,356 Sep-27-2019, 01:39 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020