I am trying to extract data from a column in an excel file and I want to be able to take the data from each row and input it into a field on my companies website.
My excel spreadsheet looks something like this..
[Column A] [Column B]
Za…
I am trying to put together 4 plots that made into one box that has all 4 shrunk into one image. e
I tried to just enter the names of my plots as arguments (ex. wshot_plot) but that does not work.
fig, axs = plt.subplots(2, 2)
axs[0,…
I’m trying to break down yearly subscriptions to monthly subscriptions by fee.
Example dataset-
import numpy as np
import pandas as pd
df = pd.DataFrame({
‘Customer_ID’: [1, 2, 3, 4, 5],
‘Plan’ : [‘Yearly’, ‘Monthly’, ‘Monthly’, ‘…
I am trying to move from using Excel to python, and pandas in particular, but am fairly new to it. So please forgive me if I have made some ‘rookie’ errors here.
I have a time series DataFrame, df, with columns ‘mad’ and ‘run’. I have adde…
I’m slowly working on a web scraper of a second-hand goods website that will ultimately download and import data (name, post code, price, date published) into excel and pair this data up with photos downloaded. I’m currently having trouble…
I have a table with a single index column looking like this:
1 2 3
Monday_0 NaN NaN NaN
Monday_1 NaN NaN NaN
Tuesday_2 NaN NaN NaN
Tuesday_3 NaN NaN NaN
I want to keep the index, but want the first part of the …
Given the following code
list_a = [‘Zara’, ‘Nike’, ‘Addidas’, ‘Uniqlo’]
list_b = [‘Nike’, ‘Addidas’]
result = []
for brand in list_a:
for brand_two in list_b:
if brand_two != brand:
result.append(brand)
print(result…
r_c = ‘newyork sanfrancisco losangeles’.split()
def my_is_r_c(c):
return c.replace(‘ ‘, ”).lower() in r_c
train[‘is_r_c’] = train[‘c_o’].apply(lambda x: 1 if my_is_r_c(x) else 0)
train[‘is_r_c’] = train[‘c_d’].apply(lambda x: 1 if m…
I have the following table. Some entries within the StockCode column have letters at the end, how do I replace these with a number?
I could make a dictionary to map each letter to a number but I feel there a quicker way to do so.
InvoiceNo…
I have 2 data frames:
df =
bancll
1 BANCLL01_20200522
2 BANCLL02_20200522
3 BANCLL03_20200522
df2 =
period dl_entityname count(*)
20200522 BANCLL01_20200522 11
20200525 BANCLL01_20200522…
I split the data I have and processed it, I need to reunite it to train the model, but the ‘DataFrame’ object has no attribute, I get a ‘concat’ error. I checked the versions. Everything is like normal.
Can you help me urgently for this pr…
I have the following dataframe:
id x_coordinate y_coordinate money time (hr)
0 545 0.676576 3.079094 4200 1.414706
1 4138 0.262979 -0.769170 700 0.943230
2 528…
I can do:
df = pd.read_csv(usage_output, parse_dates=[[‘StartDate’, ‘StartTime’],[‘EndDate’, ‘EndTime’]])
I can also do:
df = pd.read_csv(usage_output, parse_dates={‘TimeStamp_Start’: [‘StartDate’, ‘StartTime’]})
How to combine both, so …
I have a data frame to hold 4 ndarray values. 2 of them are np.ndarray size – (100,1) and 2 smaller values np.ndarray size – (10,1). Their datatypes are uint16. This is how my dataFrame looks
SN_x int64
BV_x object
SV_x obje…
I have DataFarame
date descriptions Code
1. 1/1/2020 this is aPple 6546
2. 21/8/2019 this is fan for him 4478
3. 15/3/2020 this is ball of hockey 5577
4. 12/2/2018 this is Green apple 7899
5…
I want to highlight some values into a dataframe. I need to compare 2 columns on different dataframes (df1 and df2) then highlight the values that are duplicated and show them inside the first dataframe, df1.
To give you and idea, in excel…
I have a DataFrame that looks like df = pd.DataFrame({‘col1’: [.8,.9,1,1,1,.9,1,.9,.8]}).
The goal I have is once a number 1 in ‘col1’ is found, remove the next five rows.
Example
col1
0 0.8
1 0.9
2 1.0
3 1.0
4 1.0
5 0.9
6 …
I am trying to use two data frames for a simple lookup using Pandas. I have a main master data frame (left) and a lookup data frame (right). I want to left join them on the matching integer code and return the item name from the item_df.
I…
I’m currently working with Tweepy and I made a dataframe with this
df_user = pd.DataFrame([x.user.id, x.user.name, x.user.screen_name,
x.user.location, x.user.created_at, x.user.followers_count, x.user.friends_count,
x.user.verified] f…
this is an example of a bigger dataframe:
column1
0 a
1 b
2 x
3 c
4 b
5 x
6 d
7 x
8 e
9 e
In this dataframe, I would like to select every row that has ‘x’ on it and also the exaclty rows above each of these ones. A…