I’m writing a pandas dataframe to an html file. And now I want to write that file to confluence.
I am able to log into confluence and write to it with my script, but the contents on the page are the word ‘None’ instead of the contents of t…
Below is the section of code that I’m having difficulty getting the vertical scrollbar to work for the Matplotlib chart. The chart has over 600 points along y-axis that I’m trying to use the scrollbar to scroll thru the large Matplotlib ch…
I am working on a dataframe that displays information on property rentals in Brazil. This is a sample of the dataset:
data = {
‘city’: [‘São Paulo’, ‘Rio’, ‘Recife’],
‘area(m2)’: [90, 120, 60],
‘Rooms’: [3, 2, 4],
‘Bathroom…
import time
import pandas as pd
from datetime import datetime
import webbrowser
def sign_in(meetinglink):
webbrowser.open(meetinglink)
df = pd.read_csv(‘/Users/3021118/Applications/Meeting-Launcher/timings.csv’)
while True:
…
I have a date with 6 thousand lines and 1 row. Each one of these 6 thousand lines have 5 information, and it has space between them. I want to transform each one of these 5 information into 1 row (on pandas)
So, It would be 6 thousand line…
I want to eliminate the outliers in a dataframe that has columns with different dtypes (int64 and object). I need to remove all rows that have outliers in at least one column. So, I tried to use the following code:
from scipy import stats
…
i need to time format from 2020-01-22 00:00:00+00:00 to 2020-01-22 using pandas,
this is not just a line of code put it is a data-frame.
the code is:
confirmed_file=pd.read_json(‘https://api.covid19api.com/country/egypt/status/confirmed/l…
I have about 200 files having long header lines that starts with "#" and then records with 4 columns like the following:
file_1.vcf
##some_comments that span many lines
##some_comments that span many lines
#CRHOM POS REF …
trying to convert or download dataframe into excel file with arabic data.
But when i run the script the system crash and display the below error:
AttributeError: ‘NoneType’ object has no attribute ‘encode’
Traceback:
File "F:\AIenv\li…
I need the code that worked with this issue:
Let assume I have DataFrame named as Data.
Data has three columns, X,Y and Z
enter image description here
index=[0,1,2] X=[1,3,5] Y=[1,4,8] Z=[3,4,7]
I want a code that able to find the value of…
For a school project I’m working on the kickstarter dataset on Kaggle;
https://www.kaggle.com/kemical/kickstarter-projects
In the "name" variable there’s a few titles that have spaces in between them;
e.g. instance 373 "C R …
For a school project I’m working on the kickstarter dataset on Kaggle;
https://www.kaggle.com/kemical/kickstarter-projects
In the "name" variable there’s a few titles that have spaces in between them;
e.g. instance 373 "C R …
I have this data frame where weather data is available.
Problem – My problem is when I try to add missing dates with the code below:-
dt = pd.date_range("01-01-2021","01-11-2021")
idx = pd.DatetimeIndex(dt)
new_df9 =…
Hi I have started working on a project in which i need to select the best prospect proxies for the underlying(s) based on the following hierarchy
Sector
Region (CCY)
My idea is for example if we are looking to find a suitable proxy for t…
I have more than 19k list of cities in my data set and I want to group them into four categories – East, West, North and South. I dont know how to do this in pandas. So I extracted it in excel as well. Is there a way to categorize them?
…
I am iterating through the rows of a dataframe using iterrows:
for index, row in df.iterrows():
pass
Given that the index here contains datetime objects, how can we easily access the row at the previous index (i-1) while being at leve…
I have a pandas df column that has a 10 digit timestamp? it is a type(‘O’) and I am trying to get it into datetime format of mm-dd-yyyy
date
1534636800
1534723200
1534809600
1534896000
i tried
all_data[‘datetime’] = pd.to_datetime(all_dat…
installed pandas package successfully. Import the pandas. Getting below error while run the sample code.
code:
import pandas as pd
df1 = pd.DataFrame({"A": ["A0", "A1", "A2", "A3", "A…
I have the following code:
import requests, pandas as pd
from bs4 import BeautifulSoup
s = requests.session()
url2 = r’https://www.har.com/homedetail/6408-burgoyne-rd-157-houston-tx-77057/3380601′
r = s.get(url2)
soup = BeautifulSoup(r.tex…
i am using streamlit with python in order to allow user to upload multiple files than to show the content as a dataframe.
But first i need to check if its csv type or xls, and dislay the type and name.
The problem is that when it comes to …