logo
down
shadow

Python How to convert string to dataframe?


Python How to convert string to dataframe?

By : user3042594
Date : November 28 2020, 12:01 PM
I wish this help you I print string from telnet like this code. , We can take help of StringIO with some custom adjustments:
code :
s ="""Total AP information:
fault : fault           [1]

idle  : idle            [6]
nor   : normal          [245]
ExtraInfo : Extra information
P     : insufficient power supply
---------------------------------------------------------------------------------------------------------------------------
ID    MAC            Name              Group   IP             Type     State  STA Uptime          ExtraInfo
---------------------------------------------------------------------------------------------------------------------------
0     11cc-ffff-0000 TESTAB1        @ABC1 -              AP1234N        idle   0   -               -
1     11cc-ffff-0000 TESTAB2        @ABC2 10.250.1.0     AP1234N        nor    0   11D:6H:30M:28S  -
2     11cc-ffff-0000 TESTAB3        @ABC3 10.250.2.0     AP1234N        nor    3   11D:6H:30M:11S  -"""
df=pd.read_csv(pd.compat.StringIO(s),skiprows=range(7),delim_whitespace=True)
print(df.drop(0))
from io import StringIO
df=pd.read_csv(StringIO(s),skiprows=range(7),delim_whitespace=True)
print(df.drop(0))
  ID             MAC     Name  Group          IP     Type State  STA  \
1  0  11cc-ffff-0000  TESTAB1  @ABC1           -  AP1234N  idle  0.0   
2  1  11cc-ffff-0000  TESTAB2  @ABC2  10.250.1.0  AP1234N   nor  0.0   
3  2  11cc-ffff-0000  TESTAB3  @ABC3  10.250.2.0  AP1234N   nor  3.0   

           Uptime ExtraInfo  
1               -         -  
2  11D:6H:30M:28S         -  
3  11D:6H:30M:11S         -  


Share : facebook icon twitter icon
Python: convert string [('a',0.2),('b',0.9),('a',0.4)] to dataframe

Python: convert string [('a',0.2),('b',0.9),('a',0.4)] to dataframe


By : Atanas Dimitrov
Date : March 29 2020, 07:55 AM
should help you out It sounds like you're looking to change the string into a pandas dataframe and then do some manipulations. I'd change the string to the following through some simple replaces and manual editing on the beginning and end of the string. You're escaping the punctuation except for the ends so that you can apply the eval() function.
code :
import pandas as pd

thisStr = eval('[(\'a\', 0.332), (\'d\', 0.43766), (\'b\', 0.3244), (\'b\', 0.76577), (\'a\', 0.863), (\'d\', 0.96789)]')

df = pd.DataFrame(thisStr)
df.rename(columns={0:'item', 1:'value'}, inplace=True)

# one approach to solving the problem of removing rows where
# item a has values less than 0.8.
mask = (df['item'] == 'a') & (df['value'] < 0.8)
df2 = df[~mask]
How to convert a string to a dataframe in Python

How to convert a string to a dataframe in Python


By : user7165113
Date : March 29 2020, 07:55 AM
it helps some times I use urlopen to acquire a string of data as follows.I want to convert the string to a data frame and reserve several columns, like state, AQI and so on. I do not know how to do it and want to seek advice from you. Thank you! , It seems you can use:
code :
from pandas.compat import StringIO
df = pd.read_csv(StringIO(response))
df = read_csv(URL)
Cannot convert object type to string; and then filter on that string; python pandas dataframe

Cannot convert object type to string; and then filter on that string; python pandas dataframe


By : user7656641
Date : March 29 2020, 07:55 AM
I wish did fix the issue. Convert the MarketCap column into floats by first removing the dollar signs and then substituting B with e9 and M with e6. This should make it easy to use .astype(float) on the column to do the conversion.
code :
import pandas as pd
import numpy as np


# NYSE
url_nyse = "http://www.nasdaq.com/screening/companies-by-name.aspx?letter=0&exchange=nyse&render=download"
df = pd.DataFrame.from_csv(url_nyse)
df = df.drop(df.columns[[0, 1, 3, 6,7]], axis=1)

df = df.replace({'MarketCap': {'\$': '', 'B': 'e9', 'M': 'e6', 'n/a': np.nan}}, regex=True)
df.MarketCap = df.MarketCap.astype(float)

print(df[df.MarketCap > 5000000000].head(10))
           MarketCap             Sector                                         industry
Symbol
MMM     1.419900e+11        Health Care                       Medical/Dental Instruments
WUBA    1.039000e+10         Technology  Computer Software: Programming, Data Processing
ABB     5.676000e+10  Consumer Durables                              Electrical Products
ABT     9.887000e+10        Health Care                            Major Pharmaceuticals
ABBV    1.563200e+11        Health Care                            Major Pharmaceuticals
ACN     9.388000e+10      Miscellaneous                                Business Services
AYI     7.240000e+09  Consumer Durables                                Building Products
ADNT    7.490000e+09      Capital Goods                                Auto Parts:O.E.M.
AAP     7.370000e+09  Consumer Services                           Other Specialty Stores
ASX     1.083000e+10         Technology                                   Semiconductors
Python convert list to string in the dataframe

Python convert list to string in the dataframe


By : user2489875
Date : March 29 2020, 07:55 AM
this will help You could use a list comprehension to generate a new list with the rows in id joining those entries that are lists using string.join. You can check if an entry is a list using isinstance:
code :
df['id'] = [','.join(i) if isinstance(i, list) else i for i in df['id']]
       Name                    id
0  ['John Smith']          A1005,A1006
1    ['Jane Doe']        A200,A400,A500
How to convert dataframe to string in Python

How to convert dataframe to string in Python


By : user3071823
Date : December 25 2020, 08:30 AM
wish help you to fix your issue It looks like your firstLpnTime is nested within an array.
So, you can try taking first index from this variable and then casting it using pandas.
code :
firstLpnTime = pd.to_datetime(firstLpnTime[0]).round('20T')
DatetimeIndex(['2019-07-26 15:00:00'], dtype='datetime64[ns]', freq=None)
Related Posts Related Posts :
  • Tuning the hyperparameter with gridsearch results in overfitting
  • some coordinates that I extracted from geocoder in Python are not saving in the variable I created
  • 7C in cs circles- python Im not sure what is wrong with this yet
  • How to fix 'AttributeError: 'list' object has no attribute 'shape'' error in python with Tensorflow / Keras when loading
  • python - thread`s target is a method of an object
  • Retrieve Variable From Class
  • What is the reason for matplotlib for printing labels multiple times?
  • Why would people use ThreadPoolExecutor instead of direct function call?
  • When clear_widgets is called, it doesnt remove screens in ScreenManager
  • Python can't import function
  • Pieces doesn't stack after one loop on my connect4
  • How to change font size of all .docx document with python-docx
  • How to store a word with # in .cfg file
  • How to append dictionaries to a dictionary?
  • How can I scrape text within paragraph tag with some other tags then within the paragraph text?
  • Custom entity ruler with SpaCy did not return a match
  • Logging with two handlers - one to file and one to stderr
  • How to do pivot_table in dask with aggfunc 'min'?
  • This for loop displays only the last entry of the student record
  • How to split a string by a specific pattern in number of characters?
  • Python 3: how to scrape research results from a website using CSFR?
  • Setting the scoring parameter of RandomizedSeachCV to r2
  • How to send alert or message from view.py to template?
  • How to add qml ScatterSeries to existing qml defined ChartView?
  • Django + tox: Apps aren't loaded yet
  • My css and images arent showing in django
  • Probability mass function sum 2 dice roll?
  • Cannot call ubuntu 'ulimit' from python subprocess without using shell option
  • Dataframe Timestamp Filter for new/repeating value
  • Problem with clicking select2 dropdownlist in selenium
  • pandas dataframe masks to write values into new column
  • How to click on item in navigation bar on top of page using selenium python?
  • Add multiple EntityRuler with spaCy (ValueError: 'entity_ruler' already exists in pipeline)
  • error when replacing missing ')' using negative look ahead regex in python
  • Is there a way to remove specific strings from indexes using a for loop?
  • select multiple tags by position in beautifulSoup
  • pytest: getting AttributeError: 'CaptureFixture' object has no attribute 'readouterror' capturing stdout
  • Shipping PyGObject/GTK+ app on Windows with MingW
  • Python script to deduplicate lines in multiple files
  • How to prevent window and widgets in a pyqt5 application from changing size when the visibility of one widget is altered
  • How to draw stacked bar plot from df.groupby('feature')['label'].value_counts()
  • Python subprocess doesn't work without sleep
  • How can I adjust 'the time' in python with module Re
  • Join original np array with resulting np array in a form of dictionary? multidimensional array? etc?
  • Forcing labels on histograms in each individual graph in a figure
  • For an infinite dataset, is the data used in each epoch the same?
  • Is there a more efficent way to extend a string?
  • Is it possible to do this loop in a one-liner?
  • invalid literal for int() with base 10: - django
  • Why does my code print a value that I have not assigned as yet?
  • the collatz func in automate boring stuff with python
  • How to find all possible combinations of parameters and funtions
  • about backpropagation deep neural network in tensorflow
  • Sort strings in pandas
  • How do access my flask app hosted in docker?
  • Replace the sentence include some text with Python regex
  • Counting the most common element in a 2D List in Python
  • logout a user from the system using a function in python
  • mp4 metadata not found but exists
  • Django: QuerySet with ExpressionWrapper
  • shadow
    Privacy Policy - Terms - Contact Us © festivalmusicasacra.org