Skip to content

Magenaut

  • Home
  • Topics
    • Notes
    • Tutorial
    • Bug fixing
    • Extension
    • Server
  • Q&A
  • Privacy Policy
  • About

pandas

Why does concatenation of DataFrames get exponentially slower?

August 22, 2022 by Magenaut

I have a function which processes a DataFrame, largely to process data into buckets create a binary matrix of features in a particular column using pd.get_dummies(df[col]).

Categories Python, Q&A Tags concatenation, pandas, performance, processing-efficiency, python Leave a comment

pandas create new column based on values from other columns / apply a function of multiple columns, row-wise

August 22, 2022 by Magenaut

I want to apply my custom function (it uses an if-else ladder) to these six columns (ERI_Hispanic, ERI_AmerInd_AKNatv, ERI_Asian, ERI_Black_Afr.Amer, ERI_HI_PacIsl, ERI_White) in each row of my dataframe.

Categories Python, Q&A Tags apply, numpy, pandas, python Leave a comment

UnicodeDecodeError when reading CSV file in Pandas with Python

August 22, 2022 by Magenaut

I’m running a program which is processing 30,000 similar files. A random number of them are stopping and producing this error…

Categories Python, Q&A Tags csv, dataframe, pandas, python, unicode Leave a comment

Splitting dataframe into multiple dataframes

August 21, 2022 by Magenaut

I have a very large dataframe (around 1 million rows) with data from an experiment (60 respondents).

Categories Python, Q&A Tags dataframe, pandas, python, split Leave a comment

Logical operators for Boolean indexing in Pandas

August 21, 2022 by Magenaut

I’m working with a Boolean index in Pandas.

Categories Python, Q&A Tags boolean, dataframe, filtering, pandas, python Leave a comment

Apply multiple functions to multiple groupby columns

August 21, 2022 by Magenaut

The docs show how to apply multiple functions on a groupby object at a time using a dict with the output column names as the keys:

Categories Python, Q&A Tags aggregate-functions, group-by, pandas, python Leave a comment

Deleting DataFrame row in Pandas based on column value

August 21, 2022 by Magenaut

I have the following DataFrame:

Categories Python, Q&A Tags pandas, python Leave a comment

Select rows in pandas MultiIndex DataFrame

August 21, 2022 by Magenaut

What are the most common pandas ways to select/filter rows of a dataframe whose index is a MultiIndex?

Categories Python, Q&A Tags dataframe, multi-index, pandas, python, slice Leave a comment

Aggregation in Pandas

August 21, 2022 by Magenaut

TypeError: aggregate() missing 1 required positional argument: ‘arg’

Categories Python, Q&A Tags aggregation, dataframe, pandas, pandas-groupby, python Leave a comment

Convert DataFrame column type from string to datetime

August 21, 2022 by Magenaut

How can I convert a DataFrame column of strings (in dd/mm/yyyy format) to datetimes?

Categories Python, Q&A Tags dataframe, datetime-format, pandas, python, python-datetime Leave a comment
Older posts
Newer posts
← Previous Page1 … Page11 Page12 Page13 … Page92 Next →
  1. michealSmith07 on Is there a way to dynamically refresh the less command?August 21, 2022

    That is a very nice post. I like this post.

  2. anonymous on Fix libwacom9 dependency issue when upgrade DebianJune 27, 2022

    saved my day!! Thanks for the help…

  3. sreedhar on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    Thanks its working

  4. saintnick on Fix libwacom9 dependency issue when upgrade DebianMay 10, 2022

    remove libwacom2 worked for me as well

  5. ranafoul on Fix libwacom9 dependency issue when upgrade DebianApril 22, 2022

    apt remove libwacom2 helped on kali 2022.01. gr8

.net ajax asp.net asp.net-core asp.net-mvc asp.net-mvc-3 asp.net-mvc-4 asp.net-web-api bash c# command-line css custom-post-types custom-taxonomy dataframe dictionary django entity-framework functions gridview html iis javascript jquery json linux list matplotlib numpy pandas php plugin-development plugins posts python python-2.7 python-3.x security shell shell-script sql string vb.net webforms wp-query

© 2026 Magenaut • Built with GeneratePress