What does float' object has no attribute 'replace' when I try locale.atof in Pandas?

what is float
what is float in banking
what is float in programming
how to find the float of a stock
what is a good float percentage
collection float
shares outstanding vs float
payment float

I'm trying to convert a Pandas dataframe series to float. I do locale.setlocale(locale.LC_NUMERIC, '') and then df.idh.apply(locale.atof), but it gives me the above mentioned error: AttributeError: 'float' object has no attribute 'replace'. I assume at some point it's getting something like a NaN, maybe or some other string and it does not recognize it. How do I tell apply to skip those?

Well, I don't know how "smart" this is, but I "fixed" it like this, at least for the time being:

df.idh = df.idh.astype(str).apply(locale.atof)

Please, do let me know the smart answer to this.

What Exactly Is a Company's Float?, Float is the regular shares that a company has issued to the public that are available for investors to trade. Float definition, to rest or remain on the surface of a liquid; be buoyant: The hollow ball floated. See more.

The problem has to do with null values. Replace cannot work on numpy nulls. Your solution doesn't return an error because you convert np.NaN (nulls) into 'nan' and replace can work on the string 'nan'. The problem is though that you now have 'nan' in your column instead of np.NaN. So if you run:

df[df.idh.isnull()]

It would return 0 rows even though you do have nulls in your data. The following code keeps the np.NaN while running a replace statement on that column.

def replace_percent(x):
    try: 
        return x.replace('%', '')
    except AttributeError:
        return np.NaN

df_not.secularism = df_not.secularism.map(replace_percent)

Float Definition, The float is essentially double-counted money: funds within a financial or banking system that are briefly accounted for twice due to the time gap in processing  English Language Learners Definition of float (Entry 2 of 2) : to rest on top of a liquid. : to be carried along by moving water or air. : to cause (something) to rest on top of a liquid : to cause (something) to float. See the full definition for float in the English Language Learners Dictionary.

Could this alternative solution work for you?

csv_nn = df.replace(np.nan, 'null', regex=True)

What Does Stock Float Mean?, Floating stock is the number of shares available for trade of a particular stock. The number of floating shares is referred to as the stock float or just  In computer science, a float is a data type composed of a number that is not an integer, because it includes a fraction represented in decimal format. One of the most common definitions given from experts is that a float “has numbers on both sides of the decimal.”

Float (money supply), float. General: Period between the beginning and the close of a transaction. Accounting: Small sum of money kept at hand  Float is a shortened term for "floating point." By definition, it's a fundamental data type built into the compiler that's used to define numeric values with floating decimal points. C, C++, C#and many other programming languages recognize float as a data type. Other common data types include intand double.

What does float mean? definition and meaning, A floating element is one where the computed value of float is not none . As float implies the use of the block layout, it modifies the computed  In investment terms, a float is the number of outstanding shares a corporation has available for trading. If there is a small float, stock prices tend to be volatile, since one large trade could significantly affect the availability and therefore the price of these stocks. If there is a large float, stock prices tend to be more stable.

float, Definition of float in the Definitions.net dictionary. Meaning of float. What does float mean? Information and translations of float in the most comprehensive  To answer what does float mean in stocks we need to know what a float is. The float of a stock is the number of shares that are actually available to trade. In other words, these are shares the company makes public. In other words, these are shares available for trading on the open market.

Comments
  • Got love SO. The "I don't know how 'smart' this is" just cracked me. We can all relate to this phrase
  • I didn't know how "smart" it is either, but it just helped me and worked, so it is smart.