Recent questions tagged Pandas

0 votes

1.2k views

1 answer

pandas - Download CSV from an iPython Notebook

I run an iPython Notebook server, and would like users to be able to download a pandas dataframe as a csv file so ... , I'd be happy with that. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - Timeline bar graph using python and matplotlib

I am looking to draw a timeline bar graph using matplotlib that will show the things a person did in one day. I ... , I hope you get the point See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

pandas dataframe convert column type to string or categorical

How do I convert a single column of a pandas dataframe to type string? In the df of housing data below I need to ... 1.00 2 1.0 1130 2640 98109 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

pandas - Python - Efficient way to add rows to dataframe

From this question and others it seems that it is not recommended to use concat or append to build a pandas ... add rows to this dataframe? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - Download history stock prices automatically from yahoo finance in python

Is there a way to automatically download historical prices of stocks from yahoo finance or google finance (csv format)? Preferably in Python. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

854 views

1 answer

pandas - Retain few NA's and drop rest of NA's during Stack operation in Python

I have a dataframe like shown below df2 = pd.DataFrame({'person_id':[1],'H1_date' : ['2006-10-30 00:00: ... have H5_date,H5 though they are NA's See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

989 views

1 answer

pandas - Change values in a column from a list

I've got a dataframe with my index 'Country' I want to change the name of multiple countries, I have the old/ ... over it Thanks for your help!! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

pandas - Get part of day (morning, afternoon, evening, night) in Python dataframe

Here is my dataframe , I need to create a new column based on the timehour which the row value be like (morning, ... ) or a.all(). Kindly help See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

pandas - Python: Datetime to season

I want to convert a date time series to season, for example for months 3, 4, 5 I want to replace them ... with errors. Any ideas please? Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k views

1 answer

pandas - How to remove illegal characters so a dataframe can write to Excel

I am trying to write a dataframe to an Excel spreadsheet using ExcelWriter, but it keeps returning an error: ... characters from a dataframe? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

pandas - reading excel sheet as multiindex dataframe through pd.read_excel()

I'm struggle to read a excel sheet with pd.read_excel(). My excel table looks like this ... /ipsos_excel_tables_type_2_trimed_nosig.xlsx?dl=0 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

pandas - Python: How to drop a row whose particular column is empty/NaN?

I have a csv file. I read it: import pandas as pd data = pd.read_csv('my_data.csv', sep=',') data.head() ... . What is efficient way to do it? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - Scrape tables into dataframe with BeautifulSoup

I'm trying to scrape the data from the coins catalog. There is one of the pages. I need to scrape this data into ... 3 4 174,000 5 UNC 6 - See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - which is faster for load: pickle or hdf5 in python

Given a 1.5 Gb list of pandas dataframes, which format is fastest for loading compressed data: pickle (via ... care about file size on disk See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

pandas - Python regularise irregular time series with linear interpolation

I have a time series in pandas that looks like this: Values 1992-08-27 07:46:48 28.0 1992-08-27 08:00:48 ... in advance for any help I can get. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

973 views

1 answer

pandas - python dask DataFrame, support for (trivially parallelizable) row apply?

I recently found dask module that aims to be an easy-to-use python parallel processing module. Big selling point for ... .compute() # 2.04 sec See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.4k views

1 answer

pandas - Absolute value for column in Python

How could I convert the values of column 'count' to absolute value? A summary of my dataframe this: datetime count 0 ... -20 06:00:00 73.711525 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - Python - Delete duplicates in a dataframe based on two columns combinations?

I have a dataframe with 3 columns in Python: Name1 Name2 Value Juan Ale 1 Ale Juan 1 and would like to ... Any idea will be really appreciated! See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - Python How to use ExcelWriter to write into an existing worksheet

I am trying to use ExcelWriter to write/add some information into a workbook that contains multiple sheets. First time ... this case? Any help? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

pandas - Tilde sign in python dataframe

Im new to python and came across a code snippet. df = df[~df['InvoiceNo'].str.contains('C')] Would be ... tilde signs usage in this context ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

pandas - Python: Removing Rows on Count condition

I have a problem filtering a pandas dataframe. city NYC NYC NYC NYC SYD SYD SEL SEL ... df.city. ... manually dropping them city by city? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - pyspark show dataframe as table with horizontal scroll in ipython notebook

a pyspark.sql.DataFrame displays messy with DataFrame.show() - lines wrap instead of a scroll. but displays ... editor with jupyter plugin: See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

pandas - How to remove levels from a multi-indexed dataframe?

For example, I have: In [1]: df = pd.DataFrame([8, 9], index=pd.MultiIndex.from_tuples([(1, 1, 1), (1, 3, 2)] ... .columns) Out[3]: A 1 1 8 3 9 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - Convert object data type to string issue in python

How can I convert an object dtype structure to a string dtype? The method below is not working and the ... dtypes #country object #dtype: object See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

pandas - Standard implementation of vectorize_sequences

In Fran?ois Chollet's Deep Learning with Python, appears this function: def vectorize_sequences(sequences, dimension= ... to the function above? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

926 views

1 answer

pandas - Kalman filter with varying timesteps

I have some data that represents the location of an object measured from two different sensors. So, I need to do ... "upper left") plt.show() See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

pandas - splitting at underscore in python and storing the first value

I have a pandas data frame like df with a column construct_name construct_name aaaa_t1_2 cccc_t4_10 bbbb_g3_3 and so ... suggest a fix. Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

pandas - Update Row of One DF (df1) based off matching columns between 2 dataframes (df1, df2)

I have two dataframes DF1: EmployeeID CollectiveBargainingUnit BusinessGroup ProfitCenter Eligible 1 12A A12 UGZ. 2 17A B12 MGZ. 3 ... . I need to map to multiple columns at once....

asked Jan 29, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags