Related
Bath In the example below, I am trying to check if the "value" in table 1 is within the range of values for the "start" and "stop" columns of a row in table 2 . I want to return the type of "fruit" if the value is in that range. The method in between seems to
Bath In the example below, I am trying to check if the "value" in table 1 is within the range of values for the "start" and "stop" columns of a row in table 2 . I want to return the type of "fruit" if the value is in that range. The method in between seems to
Bath In the example below, I am trying to check if the "value" in table 1 is within the range of values for the "start" and "stop" columns of a row in table 2 . I want to return the type of "fruit" if the value is in that range. The method in between seems to
Omar I need to extract values using valid dates in one table based on a range of data in another table. The most recent effective date in the range should be the new exchange rate used. df1:
ID EffectiveDate Benefit OldRate NewRate
45jk9548
gitb I have a table of 1.6M IP ranges with organization names. IP addresses will be converted to integers. The form of the table is: I have a list of 2000 unique IP addresses (eg 321223, 531223, etc.) that need to be converted to organization names. I loaded t
Grid I have two (simplified) tables in a database. Table: queuelist
'songID', 'lastplayed'
'7376', '12/01/2013'
'9322', '16/08/2012'
Table: songlist
'ID', 'artist'
'7376', 'Michael Jackson'
'2345', 'Nirvana'
'songID'and 'ID'are the same fields. I am provided
Grid I have two (simplified) tables in a database. Table: queuelist
'songID', 'lastplayed'
'7376', '12/01/2013'
'9322', '16/08/2012'
Table: songlist
'ID', 'artist'
'7376', 'Michael Jackson'
'2345', 'Nirvana'
'songID'and 'ID'are the same fields. I am provided
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
Panda I have two pandas dataframes: df1 = pd.DataFrame({'Type':list('ABCD'), 'Set':list('ZZXY')})
df2 = pd.DataFrame({'Type':list('ABCDEF'), 'Test':list('PQRSTM')})
I want to check if the value of df2['Type'] exists in df1['Type'] and if so, replace the corre
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
james I have a pandas dataframe with the following numerical structure: >>> df1
A B C
0 2 1 2
1 1 2 3
2 2 3 1
I need to replace all of the above cell values with a "description" mapped to the field name and cell value, referenced in another data
User 15407486 I have two csv files: live_file.csv Supplier SKU, Manufacturer SKU, Price
ABCD, 900000, 10
EFGH, 800000, 10
old file.csv Supplier SKU, Manufacturer SKU, Price
ABCD, 91234, 10
EFGHX, 85332, 10
I want to find the same value in the supplier SKU co
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and
Alan Taylor I currently have a string that represents a list of structures in a table. I want to look up a value in another table based on the value of an element in a struct. For example, below, the car info structure is [alternate, carType, carColour]. ╔════
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and
Alan Taylor I currently have a string that represents a list of structures in a table. I want to look up a value in another table based on the value of an element in a struct. For example, below, the car info structure is [alternate, carType, carColour]. ╔════
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and
MG SQL Muppet Good morning, I need some help. I have a database with multiple tables. I'm trying to write an INSERT INTO and SELECT query that copies all values from one table (TableA) to another (TableD), but replaces one value with the value looked up in the
Heather Stark I have a table where I want to add an extra column whose values are defined by a primary key lookup on another table. I can do this easily by creating a new table with the original table and the required extra columns : CREATE TABLE FG_LABELLED
S
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and
Alan Taylor I currently have a string that represents a list of structures in a table. I want to look up a value in another table based on the value of an element in a struct. For example, below, the car info structure is [alternate, carType, carColour]. ╔════
Alan Taylor I currently have a string that represents a list of structures in a table. I want to look up a value in another table based on the value of an element in a struct. For example, below, the car info structure is [alternate, carType, carColour]. ╔════
hedge I can hack it pretty easily, but would like to know data.tablewhat is the correct way to do this. One way is also supported dplyr. I have two data.tablelike this that year
1: 5 a 2016
2: 6 b 2016
3: 7 c 2017
4: 8 d 2018
and