Mining Horoscope

Mr. Pankaj S. Kulkarni Dr. S. S. Sane Prof. N. L. Bhale

Lecturer,IT Dept. H.O.D., Computer Dept. H.O.D., IT Dept.
K. K. W. Poly, Nashik K. K. W. I. E. E. R., Nashik Matoshri COE, Nashik
Pankaj_kulkarni1985@rediffmail.com sssane@yahoo.co.in nbhale@yahoo.com
Abstract— This paper deals with converting ancient principles Third This house rules courage, stamina, intelligence, self-
related to astrology into predictions using data mining technique. esteem, and also younger siblings in a person’s life
Horoscope has 12 regions each occupying 300. Each region is and his relationship with them, writing skills, aspects
called an “house” that deals with different significations. There of jewellery and clothes, along with prospects of short
are total 12 planets that can occupy any house in a horoscope. journeys.
According to position of the planets different angular Fourth As sukhasthan, it denotes prosperity, domestic
combinations can be formed and these combinations are termed surroundings and happiness in general. Old age,
as “Yoga’s” that are used in predicting features of horoscope. private and public affairs and inheritance can also be
Each house deals with different significations and the same set of determined from this house
combinations obtaining in a particular house might influence the
different significations comprehended by the house, in different Fifth The fifth house defines prospects in education
ways. To be more specific, let us consider the 4th house of a (Vidyasthan) and children (Putrasthan). Other than
horoscope. It is supposed to signify mother, education, land and that, it governs intellect and luck.
house properties. An illiterate person may possess many houses Sixth Sixth house tells the stories of enemies, health and
and a long-lived mother while a highly educated person may not service life.
possess any properties. This apparent inconsistency has been
reconciled to some extent by the introduction of an important Seventh Seventh house is an important house defining spouse
factor, viz., the Karaka (indicator). This paper aims at testing and conjugal happiness. This bhava includes
new horoscopes & finding out different possible angular prospects in business partnerships as well.
combinations present in that horoscope and to predict class of Eighth This house indicates diseases, Death and obstacles. It
that horoscope. This is also an approach to find out whether also determines sources of illegal income, mental
Astrology is a scientific study and application of language of the pains, the mode by which person will die, and
heavenly bodies or not. chances of imprisonment.

Keywords- Data Mining, Horoscope reading, Horoscope Ninth Wisdom, wealth, reputation and higher learning are
classification etc. all the gifts of this house.
Tenth This house defines Father, professional life and
I. INTRODUCTION overall status person will achieve in his/her lifetime.
Honor, power and authority are defined by occupation
Planets are constantly in motion with respect to earth in the and other worldly activities.
skies. There is a strong belief that the positions of Sun, Moon
and some planets close to earth can give important clues about Eleventh Eleventh house talks about income, monetary gains
and accumulated wealth. Honor and social success
the fortunes of individual human beings and groups of human also succeeds the above-mentioned qualities, hence
beings. And that is the basic premise of astrology. There are these are also defined here.
many theories and philosophies in vogue and they are
significantly different from each other. This astrological Twelfth Private enemies, charity, pleasures of bed, sorrow,
approach is known in the world by many names. Early pioneers expenditures, losses and debts are defined by the
of modern Indian astrology, like Dr. B.V. Raman, called it twelfth house in horoscope.
“Hindu astrology”, because this system was first taught by
ancient Hindu sages.
Some astronomical facts about planets:
This is an approach to find out whether Astrology is a
scientific study and application of language of the heavenly The following is a very brief description of the planets
bodies or not. Astrology is based on the fact that when the which are of relevance in vedic astrology.
environment can effect our feelings, the moon can effect so far SUN :
placed non-living (according to science) sea thus much bigger
planets like Sun, Venus etc. do effect the human behavior and This is the most important of the nine grahas. In fact the sun
it is left to us to predict what changes will they bring to our is our nearest star in the space with planets revolving around it.
lives. It is the source of all the natural light and the heat of the earth.
It provides the centripetal force to balance the centrifugal force
Sample Horoscope :
generated by the planets going around it. It's diameter is 1.392
million kilometers, which is almost 109 times the diameter of
the earth. The mass of the sun is some 323,000 times the mass
Every house in a horoscope of the earth. It has extremely high surface and core
indicates different significances. temperatures, and goes on producing immense amount of
Viz. energy. At one time the sun was considered as the center of the
universe (this was never the view of vedic astrology), but now
House Significance we know it lies near the edge of the spiral arm of the milky way
First physical appearance of the person, his basic instincts, galaxy, lying some 30,000 light years from the galactic center,
health, longevity, nature, and the basic vitality with and sharing the rotation of the galaxy.
which the person will live his life
MOON :
Second house influences throat and eyesight. Speech is also
one of the gifts of the second house. It is a satellite of the earth. In vedic astrology it is of
great importance. It is the fastest moving grah and has the usual
west to east movement along the zodiac. It has relatively small million kms. and has a diameter of about 12,000 kms. The
size, its diameter being only about 3476 kilometers. Its average rotation period of venus is 242.6 days. An important fact about
distance from the earth is about 384,400 kilometers. It always the rotation of venus is that it is retrograde, that is opposite to
presents the same face towards earth because it takes the same the general direction of rotations in the solar system. The
time to rotate once on it's axis as it does to revolve once around orbital period of venus is about 224.7 days.
the earth i.e.27.32 days. Since the rotation is a uniform motion,
while the motion in orbit is not, we may sometimes see an extra SATURN
strip of the moon's surface on one or the other side. Some 59% It is the last of the naked eye planets. It's mean distance
of the total surface of the moon may thus be visible to us on the from the sun is 1426 million kms. It's rotation period is
earth at one time or the other. This phenomenon is called as approximately 10 hours 14 minutes, and it's orbital period is
liberation. The luminosity of the moon is caused by the light 29.46 years. Saturn has a diameter of over 142 thousand miles
from the sun. It is the varying relative positions of the sun and at the equator. Being further away from the sun, saturn is a cold
the moon that produce the phases of the moon. These lunar planet . It is larger than the rest of the planets (expect jupiter)
phases, earlier discussed as tithis, are extremely important in and is about 95 times as massive as the earth. It's characteristic
Vedic astrology feature is the presence of rings around it. At least twenty
MARS satellites are known to revolve around the planet. The extra
-saturnine planets (Uranus, Neptune and Pluto) need the help of
Mars is the first of the outer planets and fourth in a telescope for their identification They do not form a part of
order of distance from the sun. Its orbit is highly elliptical as predictive vedic astrology and are, therefore, not treated of
compared to that of earth, due to which its closest position may here.
be only 56 million kms. Whereas at it's farthest it may reach up
to 100 kms. The brilliance of the mars depends upon its Astrologers designate the 12 signs as follows:
location. Mars is only twice as large than earth's moon. It's Aries, the first sign of the zodiac, is a cardinal fire sign. It is
diameter being 6786 kms. It is at a mean distance of 227.8 a positive, masculine sign, ruled by the planet Mars. Its symbol
million kms from the sun. The synodic period of the mars is is the ram, and its glyph (symbol) is said to represent a ram's
780 days, which is the interval between martian oppositions to horns. It takes its name from the Greek god of war. Aries is
the sun, with the earth lying in between. Mars rotates on it's associated with the head, and people with an Aries sun sign
own axis in 1.026 days and has an orbital period of 687 days. (the Sun is in the sign Aries in their natal chart) are prone to
Mars has two small satellites called phobo and deimos. headaches and injuries to the head and face. The association of
the head with Aries is the source of the expression "head-
MERCURY strong," which characterizes people with a strong Aries nature.
Mercury is the planet nearest to the sun and hence is Aries is dry, vernal and equinoctial (it begins on the vernal
extremely hot. It has a very eccentric orbit so it's minimum equinox), diurnal, movable, commanding, eastern, choleric,
distance (periphelion) from the sun is much less than it's and aggressive. The native, that is, the person born under its
maximum distance (aphelion). It's mean distance from the sun influence, is tall of stature, of a strong but spare make, long
is about 58 kms. and it's diameter is 4870 kms, and it's face and neck, thick shoulders, piercing eyes, sandy or red hair,
maximum inclination of about 7 degrees on either side of the and brown complexion. The native's disposition is warm,hasty,
ecliptic. Mercury rotates once round it's axis in 58.65 days and passionate. The aspects of the planets however, may
which is 2/3rd of it's orbital period of about 88 earth days. materially alter these traits. (Aspects are the angular
(planet has maximum speed at periphelion and minimum at relationships between various points in a boroscope; in a natal
aphelion). chart the planets represent the various facets of one's psyche,
and aspects between them indicate how these facets conflict or
JUPITER work together.) This sign rules the head and face. As the first
sign, the key phrase for Aries is "I am," representing the birth
Jupiter is the largest planet of the solar system, it's
of awareness.
mass exceeding that of all the other planets combined together.
It's rapid spin (once in 9 hours 50 minutes) has caused it to Taurus, the second sign of the zodiac, is a fixed earth sign.
bulge at equator (diameter at equator 143,000 kms.) and to It is a negative, feminine sign, ruled by the planet Venus. Its
flatten at the poles (diameter 133,000 kms.). It is 318 times as symbol is the bull, and its glyph is said to represent a bull's
massive as the earth and less than the 1000th part of the sun. head and horns. It takes its name from the Greek word for
It's mean distance from the earth is 778 million kms. And has "bull." A sign known for its stubbornness, it is the source of our
an orbital period of 11.86 earth years. Being far away from the expressions "bullheaded" and "stubborn as a bull." Taurus is
sun, it is a cold planet with it's gaseous cloud having a associated with the throat and neck. People with a Taurus sun
temperature of 140 deg. below freezing point. There are sign, although they often have beautiful voices, are also prone
perhaps 16 satellites which circle around Jupiter to sore throats, thyroid irregularities, and other neck problems.
Taurus is cold and dry, melancholy, nocturnal, and southern.
VENUS When influential in a nativity, it usually produces a person with
Venus is the second nearest planet to the sun. It's a broad forehead, thick lips, dark curling hair, and melancholy,
dense cloudy atmosphere reflects light extremely efficiently slow to anger, but when once enraged, violent, furious, and
and accounts for the brilliance of this planet in the sky. The difficult to appease. Places ruled by Taurus are stables, cow
maximum inclination of this orbit is about 3.24 deg. on either houses, cellars and low rooms, and all places used for or by
side of the ecliptic. It is located at a mean distance of 108 cattle. The key phrase for Taurus is "I have."
 Gemini, the third sign of the zodiac, is a mutable air sign. It takes its name from the Latin word for "pound weight," or
is a positive, masculine sign, ruled by the planet Mercury. Its "scales." Libra is associated with the lower back, buttocks, and
symbol is the twins, and its glyph is said to represent a set of kidneys. Libra is sanguine, hot, moist, and diurnal. The native
twins. It takes its name from the Latin word for "twins." is tall and well made, very handsome, of a fine, ruddy
Gemini is associated with the shoulders, arms, hands, and complexion in youth, which changes to a deep red with
lungs. The native is tall and straight with long arms and well- advancing years. The native has long, flaxen hair, gray eyes, a
formed hands and feet, rather dark complexion, brown hair, courteous disposition, and a just and upright character. The
and hazel eyes. The native is strong and active in person, sound places Libra rules are mountains, sawpits, and newly felled
and acute in judgment, lively, playful, and generally skillful in woods. The key phrase for Libra is "I balance."
business. Places ruled by Gemini are hilly and high grounds,
Scorpio, the eighth sign of the zodiac, is a fixed water sign.
the tops of houses, wainscoted rooms, halls and theaters, barns,
storehouses, and stairs. The key phrase for Gemini is "I think." It is a negative, feminine sign, ruled by the planet Pluto (in
traditional astrology it was ruled by Mars). Its symbology is
Cancer, the fourth sign of the zodiac, is a cardinal water complex, being the only sign with three symbols—the
sign. It is a negative, feminine sign, ruled by the Moon. Its scorpion, the snake, and the eagle. Its glyph is said to represent
symbol is the crab, and its glyph is said to represent the two a serpent. It takes its name from the Latin word for "scorpion."
claws of a crab. It takes its name from the Latin word for Scorpio is associated with the sexual organs and the kidneys.
"crab." A moody sign, it is the source of the expression Scorpio is a cold, nocturnal sign. The native has a strong,
"crabby." Cancer is associated with the breasts and the robust, corpulent body, is of average stature, and has a
stomach. It is a cold, moist, nocturnal, and exceedingly fruitful broad visage, dark but not clear complexion, dark gray or light
sign, more so than any other. The native is fair and pale, short brown eyes, black or very dark brown hair, short, thick legs,
and small, with the upper part of the body larger in proportion and a thick neck. Scorpio governs swampy grounds and
to the lower, a round face, light hair, and blue or gray eyes. The stagnant waters, orchards and ruinous houses, especially near
native is phlegmatic and heavy in disposition; weak in water. The key phrase for Scorpio is "I desire."
constitution, and of a small voice. Places associated with
Sagittarius, the ninth sign of the zodiac, is a mutable fire
Cancer are the sea and all rivers, swamps, ponds, lakes, wells,
ditches, and watery places. The key phrase for Cancer is "I sign. It is a positive, masculine sign, ruled by the planet Jupiter.
Its symbol is the centaur (sometimes, alternately, the archer)
feel."
and its glyph is an arrow, which refers to the arrow in the bow
Leo, the fifth sign of the zodiac, is a fixed fire sign. It is a that the centaur is holding. It takes its name from the Latin
positive, masculine sign, ruled by the Sun. Its symbol is the word sagitta, "arrow." Sagittarius is associated with the hips,
lion, and its glyph is said to be a modified version of the initial the thighs, and the liver. Sagittarius is hot, dry, and diurnal. The
letter of its Greek name. It takes its name from the Latin word native is well formed and of slightly above-average stature,
for "lion." Leo is associated with the back and, especially, the with fine chestnut hair, but inclined to baldness, a visage
heart. The association of Leo with the heart is the astrological somewhat long but ruddy and handsome. The body is
basis for the common expression "lion hearted." Leo is hot, strong, stout, and hardy. The native is inclined
dry, commanding, and very barren. When this sign ascends in a to horsemanship and field sports, careless of danger, generous
nativity, the individual has a tall and powerful frame and is and intrepid, but hasty and careless. Sagittarius rules the hips
well shaped, with an austere countenance, light, yellowish hair, and is the cause of gout, rheumatism, and disorders that affect
large piercing eyes, commanding aspect, the muscles. Accidents and disorders occasioned by
and ruddy complexion. The character is fierce and aggressive, intemperance come under the government of this sign.
yet open, generous, and courteous. This sign is more modified Sagittarius is associated with stables and parks. The key phrase
by planetary influences than any other. Leo governs woods, for Sagittarius is "I see."
forests, deserts and hunting grounds, and fireplaces and
Capricorn, the tenth sign of the zodiac, is a cardinal earth
furnaces. The key phrase for Leo is "I will."
sign. It is a negative, feminine sign, ruled by the planet Saturn.
Virgo, the sixth sign of the zodiac, is a mutable earth sign. Its symbol is a goat with a fishtail, and its glyph is said to
It is a negative, feminine sign, ruled by the planet Mercury. Its reflect this symbol. It takes its name from the Latin
symbol is a young woman, and its glyph is said to represent a capricornus, "goat horn." Capricorn is associated with the
serpent. Virgo takes its name from the Latin word for "virgin." bones and, especially, with the knees. It is a cold, dry,
Virgo is associated with the nervous system and, especially, nocturnal, domestic sign. The native usually is tall, of slender
with the bowels. Virgo is cold, dry, barren, and melancholy. stature and long, thin countenance, with a small beard, dark
The native is handsome and well shaped, slender, of average hair and eyes, long neck, and narrow chest and chin. The native
stature, with a clear, ruddy or brown complexion, dark hair and is cheerful and collected, talented and upright. Ruling the knees
eyes, a rather round face, and a voice sweet and clear but not and hips, Capricorn governs all diseases that afflict them, and
strong. The character is amiable and benevolent, witty also melancholy diseases such as hypochondriasis and hysteria.
and studious, but not persevering; and if not opposed by The places over which it has power are workshops
planetary aspects, apt to oratory. Virgo is associated with and fallow grounds. The key phrase for Capricorn is "I use."
cornfields and granaries, studies and libraries. The key phrase
Aquarius, the eleventh sign of the zodiac, is a fixed air sign.
for Virgo is "I analyze."
It is a positive, masculine sign, ruled by the planet Uranus
Libra, the seventh sign of the zodiac, is a cardinal air sign. (before the outer planets were discovered, it was said to be
It is a positive, masculine sign, ruled by the planet Venus. Its ruled by Saturn). Its symbol is the water bearer, and its glyph is
symbol is the scales, which its glyph is said to represent. It a pair of wavy lines representing water. Aquarius is associated
with the shins, ankles, and the circulatory system. Aquarius is a Moon Not Null Number
hot, moist, rational, sanguine sign. The native is a well-made Mars Not Null Number
and robust person, of above-average stature, long face, but with Mercury Not Null Number
a pleasing and delicate countenance, clear, bright complexion, Jupiter Not Null Number
and flaxen hair. The native is fair, open, and honest. Aquarius Venus Not Null Number
rules the legs and ankles and causes all diseases that affect Saturn Not Null Number
them: lameness, swelling, cramping, and gout. It governs mines Rahu Not Null Number
and quarries, flying machines, roofs of houses, wells, and Ketu Not Null Number
conduits. The key phrase for Aquarius is "I know." Uranus Not Null Number
Neptune Not Null Number
Pisces, the twelfth sign of the zodiac, is a mutable water Pluto Not Null Number
sign. It is a negative, feminine sign, ruled by the planet Type Not Null Varchar
Neptune (in traditional astrology it was ruled by Jupiter). Its
symbol is two fish moving in opposite directions, tied together
by a rope. Its glyph is said to be a stylized representation of this The values are inserted in the database as,
symbol. It takes its name from the plural of the Latin word for Ascendent 2
"fish." Pisces is associated with the feet. It is a cold, moist, Sun 4
nocturnal, and extremely fruitful sign, second only to Cancer. Moon 4
The native is short and ill shaped, fleshy, if not corpulent, with Mars 3
thick, round shoulders, light hair and eyes, pale complexion, Mercury 4
and a large head and face. The native has a weak Jupiter 7
and vacillating disposition and is well-meaning but devoid of Venus 4
energy. Pisces rules the feet and causes lameness and every Saturn 4
kind of disorder occasioned by watery humors. Pisces governs Rahu 2
the same places as Cancer, except for the sea and rivers. The Ketu 8
key phrase for Pisces is "I believe." Uranus 5
Neptune 5
Pluto 6
Type Engineer
II. HOROSCOPE CHART :
Is the one in which the order of the houses is fixed. It
consists of four central rhomboidal houses (which are The database can be created for many such horoscopes.
numbered 1, 4,7 and 10, starting from the upper central This database will serve as the training set in predicting the
rhomboid) and eight triangular houses. The sign rising at the newer dataset. The training set will contain many horoscopes &
time of birth is marked in the first house or the upper central is given as input to the classifying algorithm in WEKA.
rhomboid, and the remaining signs marked in regular order in
an anti-clockwise direction.

V. INTERFACING WEKA WITH HOROSCOPE :

III. CREATING A DATABASE FROM ABOVE HOROSCOPE :

Every horoscope contains 12 planets, 12 different signs &
12 different houses. Depending on the placement of all these
different angular combinations are formed. A horoscope can be Fig:Applying Horoscope to the WEKA
identified by 13 attributes viz. Ascendant sign & signs of 12
Planets. A 14th attribute may be added to represent the type of
that horoscope e.g. a politician, a doctor etc.
VI. WEKA (WAIKATO ENVIRONMENT FOR KNOWLEDGE
ANALYSIS) :
IV. TABLE STRUCTURE :-
Attribute Constraints Datatype WEKA is a collection of machine learning algorithms for
Ascendent Not Null Varchar data mining tasks. The algorithms can either be applied directly
Sun Not Null Number
to a dataset or called from your own Java code. WEKA Research. He has also worked as the Head of the Information
contains tools for data pre-processing, classification, Technology Department at that institute.
regression, clustering, association rules, and visualization. It is
also well-suited for developing new machine learning schemes.
A database created above can be given as input to the Prof. N. L. Bhale
WEKA algorithm such as Neural Networks, Lazy, Decision Has completed bachelors degree in Comp. Engg. from
Tree etc. & a model can be built up from this input. This model Govt. College of Engg, Amravati, M.Tech. from Dr.
is then used in predicting the nature of new horoscope. Babasaheb Ambedkar Technological University, Lonere.
Currently he is working as Head Of Dept of Information
VII. ABOUT THE AUTHORS Technology in Matoshri Engg. College & has more than 18
years of experience in the education field.

Mr. Pankaj S. Kulkarni

Has completed Bachelors degree in Computer Engineering VIII. CONCLUSION
from K. K. Wagh Institute of Engineering, Education & Converting the ancient principles related to astrology into
Research, Nashik. Currently Working as lecturer in K. K. predictions using data mining technique is possible & helpful
Wagh Polytechnic, Nashik. in predicting the nature of the horoscope.

IX. REFERENCE
Dr. S. S. Sane
Prof. Dr. Shirish S Sane obtained his Diploma in [1] Maharashtracha Kundali Sangrah by V. D. Bhat
Electronics and Radio Engineering in the year 1984 from the [2] Saravalli By Kalyan Varma
Cusrow Wadia Institute of Technogy, Pune and obtained his [3] 300 Important combinations, B.V. Raman
bachelors degree in Computer Engineering from the Pune [4] Judging Horoscope, B. V. Raman
Institute of Computer Technology (PICT), Pune in the year [5] Brihat Jatak , Kalyan Verma
1987. He then worked as a Software Engineer at the [6] Jatak Sangraha, Pt. Navathe
“Algorhythms Computer Software Consultants”, Pune. With [7] www.astrocamp.com/about-kundalini-yoga-chakras.html
his passion towards the field of Education, he joined the K K
[8] Data Mining: A Knowledge Discovery Approach, K. Cios, W. Pedrycz,
Wagh Institute of Engineering Education & Research, formerly R. Swiniarski, L. Kurgan, Springer, ISBN: 978-0-387-33333-5, 2007.
called the K K Wagh College of Engineering, Nashik in the [9] Data Mining: Concepts, Models, Methods, and Algorithms, Mehmed
year 1988. He obtained his Masters Degree M. Tech in Kantardzic, ISBN: 0471228524, Wiley-IEEE Press, 2002.
Computer Science & Engineering from Indian Institute of [10] Ian Witten and Eibe Frank, Data Mining: Practical Machine Learning
Technology (IIT), Mumbai in the year 1995. Obtained PhD in Tools and Techniques, 2nd Edition, Morgan Kaufmann, ISBN
Data Mining from Pune University. Since the year 1998, he is 0120884070,2005.
working as the Head of the Computer Engineering Department [11] WEKA manual.
and the Professor Incharge of the “Kusumagraj” Central [12] http://www.cs.waikato.ac.nz/ml/weka/index_documentation.html
Library at the K K Wagh Institute of Engineering Education & [13] http://www.astrocamp.com/astrology-analysis-moon-profession.html