In [ ]: import pandas as pd
In [ ]: df=pd.read_csv(r"C:\Users\Dell\Downloads\diabetes_unclean (1).csv")
In [ ]: df
In [ ]: df['total_values']=(df['LDL']+df['VLDL'])
df
In [ ]: df['medical condition']='good/bad'
In [ ]: [Link][df['total_values']>=4,df['medical condition']]='bad'
In [ ]: [Link][df['total_values']>=4,df['medical_condition']]='good'
In [ ]: df
In [1]: import pandas as pd
In [6]: india_weather= [Link]({'city':['mumbai','delhi','bangalore'],'temperature':[3
In [3]: india_weather
Out[3]: city temperature humidity
0 mumbai 36 68
1 delhi 35 65
2 bangalore 38 75
In [7]: us_weather= [Link]({'city':['new york','Houston','portland'],'temperature':[3
In [8]: us_weather
Out[8]: city temperature humidity
0 new york 36 23
1 Houston 25 65
2 portland 27 66
In [14]: df= [Link]([india_weather,us_weather])
In [10]: df
Out[10]: city temperature humidity
0 mumbai 36 68
1 delhi 35 65
2 bangalore 38 75
0 new york 36 23
1 Houston 25 65
2 portland 27 66
In [12]: india_temp=[Link]({'city':['delhi','mumbai','bangalore'],
'temp':[23,36,46]})
india_temp
Out[12]: city temp
0 delhi 23
1 mumbai 36
2 bangalore 46
In [13]: india_humidity=[Link]({'city':['delhi','mumbai','bangalore'],
'humidity':[25,37,56]})
india_humidity
Out[13]: city humidity
0 delhi 25
1 mumbai 37
2 bangalore 56
In [16]: gg= [Link](india_temp,india_humidity,on='city')
In [17]: gg
Out[17]: city temp humidity
0 delhi 23 25
1 mumbai 36 37
2 bangalore 46 56
In [63]: df1=[Link](columns=['temp','humidity'])
df1
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
Cell In[63], line 1
----> 1 df1=[Link](columns=['temp','humidity'])
2 df1
File ~\anaconda3\Lib\site-packages\pandas\core\[Link], in [Link](sel
f, labels, axis, index, columns, level, inplace, errors)
5433 def drop(
5434 self,
5435 labels: IndexLabel | None = None,
(...)
5442 errors: IgnoreRaise = "raise",
5443 ) -> DataFrame | None:
5444 """
5445 Drop specified labels from rows or columns.
5446
(...)
5579 weight 1.0 0.8
5580 """
-> 5581 return super().drop(
5582 labels=labels,
5583 axis=axis,
5584 index=index,
5585 columns=columns,
5586 level=level,
5587 inplace=inplace,
5588 errors=errors,
5589 )
File ~\anaconda3\Lib\site-packages\pandas\core\[Link], in [Link](sel
f, labels, axis, index, columns, level, inplace, errors)
4786 for axis, labels in [Link]():
4787 if labels is not None:
-> 4788 obj = obj._drop_axis(labels, axis, level=level, errors=errors)
4790 if inplace:
4791 self._update_inplace(obj)
File ~\anaconda3\Lib\site-packages\pandas\core\[Link], in NDFrame._drop_axi
s(self, labels, axis, level, errors, only_slice)
4828 new_axis = [Link](labels, level=level, errors=errors)
4829 else:
-> 4830 new_axis = [Link](labels, errors=errors)
4831 indexer = axis.get_indexer(new_axis)
4833 # Case for non-unique axis
4834 else:
File ~\anaconda3\Lib\site-packages\pandas\core\indexes\[Link], in [Link](s
elf, labels, errors)
7068 if [Link]():
7069 if errors != "ignore":
-> 7070 raise KeyError(f"{labels[mask].tolist()} not found in axis")
7071 indexer = indexer[~mask]
7072 return [Link](indexer)
KeyError: "['temp', 'humidity'] not found in axis"
In [ ]: df1
In [23]: india_temp=[Link]({'temp':[23,36,46]})
In [25]: india_temp
Out[25]: temp
0 23
1 36
2 46
In [26]: df2=[Link]('india_temp')
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
~\AppData\Local\Temp\ipykernel_29584\[Link] in ?()
----> 1 df2=[Link]('india_temp')
~\anaconda3\Lib\site-packages\pandas\core\[Link] in ?(self, name)
6295 and name not in self._accessors
6296 and self._info_axis._can_hold_identifiers_and_holds_name(name)
6297 ):
6298 return self[name]
-> 6299 return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'append'
In [2]: import pandas as pd
In [3]: df=pd.read_csv(r"C:\Users\Dell\Downloads\diabetes_unclean (1).csv")
In [4]: df
Out[4]: ID No_Pation Gender AGE Urea Cr HbA1c Chol TG HDL LDL VLDL BM
0 502 17975 F 50.0 4.7 46.0 4.9 4.2 0.9 2.4 1.4 0.5 24.0
1 735 34221 M 26.0 4.5 62.0 4.9 3.7 1.4 1.1 2.1 0.6 23.0
2 420 47975 F 50.0 4.7 46.0 4.9 4.2 0.9 2.4 1.4 0.5 24.0
3 680 87656 F 50.0 4.7 46.0 4.9 4.2 0.9 2.4 1.4 0.5 24.0
4 504 34223 M 33.0 7.1 46.0 4.9 4.9 1.0 0.8 2.0 0.4 21.0
... ... ... ... ... ... ... ... ... ... ... ... ... ..
1004 191 454316 M 55.0 NaN 62.0 6.8 5.3 2.0 1.0 3.5 0.9 30.1
1005 192 454316 M 55.0 4.8 88.0 NaN 5.7 4.0 0.9 3.3 1.8 30.0
1006 193 454316 M 62.0 6.3 82.0 6.7 5.3 2.0 1.0 3.5 NaN 30.1
1007 194 454316 F 57.0 4.1 70.0 9.3 5.3 3.3 1.0 1.4 1.3 29.0
1008 195 4543 f 55.0 4.1 34.0 13.9 5.4 1.6 1.6 3.1 0.7 33.0
1009 rows × 14 columns
In [5]: h=df.sort_values(by=['HDL'])
h
Out[5]: ID No_Pation Gender AGE Urea Cr HbA1c Chol TG HDL LDL VLDL BMI
691 214 27458 F 55.0 4.5 34.0 10.4 4.7 2.5 0.2 3.4 1.1 28.36
759 193 48088 F 55.0 6.0 43.0 11.2 2.4 1.3 0.4 1.4 0.6 32.00
525 557 34417 M 55.0 4.2 68.0 8.3 4.8 3.1 0.4 2.4 1.4 33.00
764 619 34528 F 60.0 6.6 43.0 11.2 2.4 1.3 0.4 1.4 0.6 26.00
762 455 34527 M 60.0 6.2 35.0 8.5 5.8 2.9 0.4 3.0 1.6 32.00
... ... ... ... ... ... ... ... ... ... ... ... ... ..
415 787 34361 F 52.0 6.4 88.0 8.5 8.5 0.8 6.6 1.3 1.3 33.00
412 443 24119 F 52.0 6.4 88.0 8.5 8.5 0.8 6.6 1.3 1.3 33.00
816 181 45511 F 55.0 5.5 50.0 12.2 6.3 2.3 9.0 4.4 1.0 31.00
752 154 34522 F 56.0 4.5 57.0 11.8 3.9 3.1 9.9 1.8 1.4 33.00
999 248 24054 M 54.0 5.0 67.0 6.9 3.8 1.7 NaN 3.0 0.7 33.00
1009 rows × 14 columns
In [6]: h=df.sort_values(by=['HDL'],ascending=False)
h
Out[6]: ID No_Pation Gender AGE Urea Cr HbA1c Chol TG HDL LDL VLDL BMI
752 154 34522 F 56.0 4.5 57.0 11.8 3.9 3.1 9.9 1.8 1.4 33.00
816 181 45511 F 55.0 5.5 50.0 12.2 6.3 2.3 9.0 4.4 1.0 31.00
412 443 24119 F 52.0 6.4 88.0 8.5 8.5 0.8 6.6 1.3 1.3 33.00
415 787 34361 F 52.0 6.4 88.0 8.5 8.5 0.8 6.6 1.3 1.3 33.00
447 220 34375 M 60.0 5.1 59.0 9.0 4.5 1.6 6.3 2.0 1.0 37.00
... ... ... ... ... ... ... ... ... ... ... ... ... ..
762 455 34527 M 60.0 6.2 35.0 8.5 5.8 2.9 0.4 3.0 1.6 32.00
764 619 34528 F 60.0 6.6 43.0 11.2 2.4 1.3 0.4 1.4 0.6 26.00
525 557 34417 M 55.0 4.2 68.0 8.3 4.8 3.1 0.4 2.4 1.4 33.00
691 214 27458 F 55.0 4.5 34.0 10.4 4.7 2.5 0.2 3.4 1.1 28.36
999 248 24054 M 54.0 5.0 67.0 6.9 3.8 1.7 NaN 3.0 0.7 33.00
1009 rows × 14 columns
In [16]: g=[Link]([[8,5,6],[2,8,9]], columns=['pen','pencil','sharpener'])
g
Out[16]: pen pencil sharpener
0 8 5 6
1 2 8 9
In [8]: h=[Link]([[9,8,3],[5,8,9]], columns=['pen','pencil','sharpener'])
h
Out[8]: pen pencil sharpener
0 9 8 3
1 5 8 9
In [2]: pip install numpy
Requirement already satisfied: numpy in c:\users\dell\anaconda3\lib\site-packages
(1.26.4)
Note: you may need to restart the kernel to use updated packages.
In [14]: h2=[Link]([h,g],ignore_index=True)
h2
Out[14]: pen pencil sharpener
0 9 8 3
1 5 8 9
2 8 5 6
3 2 8 9
In [15]: h2=[Link]([h,g])
h2
Out[15]: pen pencil sharpener
0 9 8 3
1 5 8 9
0 8 5 6
1 2 8 9
In [3]: import numpy as np
In [18]: z= [4,5,8]
z
Out[18]: [4, 5, 8]
In [19]: type(z)
Out[19]: list
In [21]: npa=[Link](z)
npa
Out[21]: array([4, 5, 8])
In [24]: print(type(npa))
<class '[Link]'>
In [27]: a=[Link]([0,1,2,3])
a
Out[27]: array([0, 1, 2, 3])
In [30]: [Link]
Out[30]: 1
In [31]: d=[Link]([[0,1,2,3],[0,4,5,3]])
d
Out[31]: array([[0, 1, 2, 3],
[0, 4, 5, 3]])
In [32]: [Link]
Out[32]: 2
In [34]: mymatrix=[[1,2,3],[4,5,6],[8,9,7]]
mymatrix
Out[34]: [[1, 2, 3], [4, 5, 6], [8, 9, 7]]
In [35]: [Link](mymatrix).shape
Out[35]: (3, 3)
In [41]: c=[Link]([[[0,1],[2,3]],[[4,5],[7,8]]])
c
Out[41]: array([[[0, 1],
[2, 3]],
[[4, 5],
[7, 8]]])
In [42]: [Link]
Out[42]: 3
In [46]: a=[Link](2,9,9)
a
Out[46]: array([2. , 2.875, 3.75 , 4.625, 5.5 , 6.375, 7.25 , 8.125, 9. ])
In [51]: b=[Link](10)
b
Out[51]: array([0, 1, 2, 3, 4, 5, 6, 7, 8, 9])
In [52]: b=[Link](1,10,2)
b
Out[52]: array([1, 3, 5, 7, 9])
In [54]: [Link](3)
Out[54]: array([0., 0., 0.])
In [55]: [Link]((2,2))
Out[55]: array([[0., 0.],
[0., 0.]])
In [56]: [Link]((4,3))
Out[56]: array([[1., 1., 1.],
[1., 1., 1.],
[1., 1., 1.],
[1., 1., 1.]])
In [59]: c=[Link](3,20)
c
Out[59]: array([[1., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0.,
0., 0., 0., 0.],
[0., 1., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0.,
0., 0., 0., 0.],
[0., 0., 1., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0., 0.,
0., 0., 0., 0.]])
In [60]: a=[Link]([7,8,9,10])
a
Out[60]: array([[ 7, 0, 0, 0],
[ 0, 8, 0, 0],
[ 0, 0, 9, 0],
[ 0, 0, 0, 10]])
In [61]: a=[Link](1,121,5)
a
Out[61]: array([117, 13, 2, 11, 120])
In [6]: a=[Link]([1,2,3,4])
b=[Link]([5,2,2,4])
a==b
Out[6]: array([False, True, False, True])
In [7]: a=[Link]([1,2,3,4])
b=[Link]([5,2,2,4])
c=[Link]([1,2,3,4])
In [8]: np.array_equal(a,b)
Out[8]: False
In [9]: np.array_equal(a,c)
Out[9]: True
In [11]: a=[Link]([1,1,0,0],dtype=bool)
b=[Link]([1,0,1,0],dtype=bool)
np.logical_or(a,b)
Out[11]: array([ True, True, True, False])
In [12]: a=[Link]([1,1,0,0],dtype=bool)
b=[Link]([1,0,1,0],dtype=bool)
np.logical_and(a,b)
Out[12]: array([ True, False, False, False])
In [13]: a=[Link](5)
[Link](a)
Out[13]: array([ 0. , 0.84147098, 0.90929743, 0.14112001, -0.7568025 ])
In [14]: [Link](a)
C:\Users\Dell\AppData\Local\Temp\ipykernel_20252\[Link]: RuntimeWarning: div
ide by zero encountered in log
[Link](a)
Out[14]: array([ -inf, 0. , 0.69314718, 1.09861229, 1.38629436])
In [15]: [Link](a)
Out[15]: array([ 1. , 2.71828183, 7.3890561 , 20.08553692, 54.59815003])
In [19]: x=[Link]([1,2,3,4])
[Link](x)
Out[19]: 10
In [20]: x=[Link]([[1,1],[2,2]])
x
Out[20]: array([[1, 1],
[2, 2]])
In [21]: [Link](axis=0)
Out[21]: array([3, 3])
In [22]: [Link](axis=1)
Out[22]: array([2, 4])
In [23]: x=[Link]([1,3,2])
[Link]()
Out[23]: 1
In [24]: [Link]()
Out[24]: 3
In [26]: [Link]()
Out[26]: 0
In [27]: [Link]()
Out[27]: 1
In [29]: arr=[Link](0,10,1)
arr
Out[29]: array([0, 1, 2, 3, 4, 5, 6, 7, 8, 9])
In [30]: [Link](arr)
Out[30]: 4.5
In [31]: [Link](arr)
Out[31]: 4.5
In [32]: [Link](arr)
Out[32]: 2.8722813232690143
In [33]: [Link](arr)
Out[33]: 0
In [34]: [Link](arr)
Out[34]: 9
In [33]: import pandas as pd
import numpy as np
import [Link] as plt
import seaborn as sns
In [3]: df = [Link]({'Length':[Link](500)})
[Link]()
Out[3]: Length
0 -0.389981
1 0.207945
2 0.550208
3 1.229969
4 0.065271
In [4]: df['Length'].hist() #pandas
[Link]()
In [8]: [Link](df['Length'])
[Link]()
In [10]: [Link](df['Length'],bins=15)
[Link]('Length')
[Link]('Count')
[Link]('Histogram of Length')
[Link]()
In [11]: [Link](df['Length'],bins=15,orientation='horizontal')
[Link]('Length')
[Link]('Count')
[Link]('Histogram of Length')
[Link]()
In [50]: import pandas as pd
import numpy as np
import [Link] as plt
In [14]: df = [Link]({'Length':[Link](500)})
[Link]()
Out[14]: Length
0 -1.141807
1 1.965798
2 -1.360123
3 -0.313278
4 1.165918
In [16]: [Link](df['Length'])
[Link]()
In [17]: [Link](df['Length'],notch=True)
[Link]()
In [19]: x=[Link](1,11)
y=[Link](11,21)
[Link](x,y)
[Link]()
In [24]: x=[Link](1,11)
y=[Link](11,21)
[Link](x,y)
[Link]('x values')
[Link]('y values')
[Link]('2D scatter plot')
[Link]()
In [29]: [Link]([16,12,10,15,14,17,19,11,15,13],color='pink',linewidth=5.0)
[Link]('x values')
[Link]('y values')
[Link]('2D lines plot')
[Link]()
[Link](4,12,'Sales')
[Link]()
In [31]: x= [1,2.1,0.4,8.9,3.5,6.5,8.5,3.4]
y=[2,3.4,8.4,0.5,2.5,3.5,3.5,8.5]
[Link](x,y,color='turquoise',marker='+',linestyle='--',markersize=10)
[Link]()
In [34]: x=[1,2,3,4,5,6,7]
y=[45,45,42,48,46,42,41]
[Link](2,2,1)
[Link](x,y,'r--')
[Link](2,2,2)
[Link](x,y,'g*--')
[Link](2,2,3)
[Link](x,y,'bo',linewidth=2, linestyle='dashed')
[Link](2,2,4)
[Link](x,y,'go',linestyle='dashed')
Out[34]: [<[Link].Line2D at 0x17174f96c00>]
In [35]: list=[20,80,15,10,20,5]
lbl=['facecream','facewash','toothpaste','soap','shampoo','moisturizer']
In [41]: [Link](list,labels=lbl,autopct='%1.1f%%')
[Link]()
In [48]: la= ['python','c++','java','ruby']
sizes=[215,130,205,210]
co=['gold','yellowgreen','red','lightskyblue']
explode=(0,0.1,0,0)
[Link](sizes,explode=explode, labels=la, colors=co, autopct='%1.1f%%')
[Link]('equal')
[Link]('[Link]')
[Link]()
In [49]: marks=[81,90,95,85,72]
roll_no=[11,12,13,14,15]
[Link](roll_no, marks)
[Link]('roll_no')
[Link]('marks')
[Link]()
In [54]: import pandas as pd
import numpy as np
import [Link] as plt
import seaborn as sns
In [59]: companies=['Amazon','FB','Google','GE']
profit=[50,60,120,52]
revenue=[60,80,150,82]
[Link](companies,profit,label='Profit')
[Link]('Top US Firms Stocks')
[Link]()
[Link]()
In [60]: companies=['Amazon','FB','Google','GE']
profit=[50,60,120,52]
revenue=[60,80,150,82]
[Link](companies,profit,label='Profit')
[Link](companies,revenue,label='Revenue')
[Link]('Top US Firms Stocks')
[Link]()
[Link]()
In [61]: df=pd.read_csv(r"C:\Users\Dell\Downloads\[Link]")
In [65]: df
Out[65]: total_bill tip sex smoker day time size
0 16.99 1.01 Female No Sun Dinner 2
1 10.34 1.66 Male No Sun Dinner 3
2 21.01 3.50 Male No Sun Dinner 3
3 23.68 3.31 Male No Sun Dinner 2
4 24.59 3.61 Female No Sun Dinner 4
... ... ... ... ... ... ... ...
239 29.03 5.92 Male No Sat Dinner 3
240 27.18 2.00 Female Yes Sat Dinner 2
241 22.67 2.00 Male Yes Sat Dinner 2
242 17.82 1.75 Male No Sat Dinner 2
243 18.78 3.00 Female No Thur Dinner 2
244 rows × 7 columns
In [64]: [Link]()
<class '[Link]'>
RangeIndex: 244 entries, 0 to 243
Data columns (total 7 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 total_bill 244 non-null float64
1 tip 244 non-null float64
2 sex 244 non-null object
3 smoker 244 non-null object
4 day 244 non-null object
5 time 244 non-null object
6 size 244 non-null int64
dtypes: float64(2), int64(1), object(4)
memory usage: 13.5+ KB
In [67]: [Link]()
Out[67]: total_bill tip sex smoker day time size
0 16.99 1.01 Female No Sun Dinner 2
1 10.34 1.66 Male No Sun Dinner 3
2 21.01 3.50 Male No Sun Dinner 3
3 23.68 3.31 Male No Sun Dinner 2
4 24.59 3.61 Female No Sun Dinner 4
In [68]: [Link](df['size'],df['total_bill'])
[Link]('Size')
[Link]('Total Bill')
[Link]('Total bill Vs Size')
[Link]()
In [73]: [Link](df['size'])
[Link](df['tip'])
[Link]()
In [ ]: